An Excel spreadsheet, like other documents that you might create in Microsoft Office programs such as Word or Powerpoint, will print as much information on one page as it can. One way around this is to use page breaks to force content onto a new page. But you might need to know how to remove … Read more
Print settings are often an afterthought when working with data in Excel, but it can quickly turn into a headache when you print your spreadsheet and discover that nothing is right. You might not have any lines between cells, data might be cutting off and going on to its own page, and you may even … Read more
One useful thing that you can do when working with Excel worksheets that are going to print on multiple sheets of paper is to ensure that those pages are numbered. This will make it easy to re-establish the page order in case the pages ever wind up in the wrong order. It can also help … Read more
Adding text boxes in Microsoft Excel may seem odd, considering the layout of a spreadsheet and the way that the application is generally. But you can definitely encounter situations where text boxes are a preferable choice for some data or information. The ability to move the text box alone can make it appealing, and you … Read more
Making a spreadsheet print properly can be difficult. As the file grows larger and the data uses more pages, readers might have trouble remembering what information belongs to which row. One way to improve this is to set a column to repeat the left side of each page in Excel. No matter what you use … Read more
While your primary concern when working with data in an Excel spreadsheet may be ensuring that the data is correct, you may also need to consider its physical size. This can be tough to visualize on the screen, which could leave you looking for a way to add an on screen ruler. When you are … Read more
Excel has a combination of default settings that are meant to appeal to a large number of users. One of these settings is the view, which is how new spreadsheets look when you create one. But if you prefer a different view and always change it, then you may be wondering how to change Excel’s … Read more
Text formatting effects like bold, italic, and underline can be useful when displaying data in Excel. But if some of your data has a line through it, then you may be looking for a way to remove strikethrough in Excel. The strikethrough effect in Microsoft Excel 2010 is helpful when you wish to indicate that … Read more
Locking a worksheet in Excel can be a useful tool depending on how that worksheet is being shared. But someone viewing a locked spreadsheet might need to edit it, so it’s helpful to know how to remove a password in Excel 2010. Microsoft Excel files are often shared between students and colleagues who are attempting … Read more
Creating a drop down list in Excel 2010 is something that seems like it should be fairly simple, as its a helpful item to have, and there are a lot of uses for it. But if you’ve ever tried to make a dropdown in Excel, then you may have found that it’s a little more … Read more