Using borders and gridlines in your spreadsheet can provide a clean and simple way to separate information in different cells. But adding borders to your cells is not the same as adding a border to a text box, as Excel treats those two objects a little differently. A text box in Excel 2013 is its […]

Excel spreadsheets rarely print how you want them to, and properly configuring a spreadsheet for the physical page is often cited as one of the bigger frustrations for Excel users. There are some quick ways to simplify the process, such as fitting a spreadsheet to one page, but that isn’t always practical for larger worksheets. […]

Excel spreadsheets show a pattern of lines on the screen that represent the perimeters of the cells. These are called gridlines, and they make it easier to distinguish different cells from one another. But gridlines can be overridden by cell fill colors, so you may be looking for a way to regain those cell perimeters. […]

Informative spreadsheets often contain a large amount of data that you can use to answer related questions. But not every situation will require all of the data contained in that spreadsheet, so you may need to remove some unnecessary rows. But deleting rows from your spreadsheet may not be appealing if you need that information […]

While it is customary to display data in Excel in the cells of the spreadsheet, situations can arise where you need to display your information in a way that will not affect the layout of the rest of your cells. An ideal solution to this is a text box, which can be customized independently of […]

Repeating information at the top of each printed page of an Excel spreadsheet is helpful when you wish to include a report name or some other type of identifying information with the spreadsheet. This can be accomplished by adding a header to your document. The header and footer in Excel can be used for more than […]

Many Excel 2013 users will find that they need to adjust their print settings so that their spreadsheets fit better on a printed page. We have previously written about ways to make Excel printing a little easier, but many of the settings that adjust the print size will not affect the layout of the spreadsheet […]

Excel 2013 is compatible with a variety of different file formats, and you can even choose the default format in which Excel 2013 files are saved. The file type can also be selected on a file-by-file basis, which is helpful when you have contacts that require their data in a particular format. One popular format […]

It is helpful to add page numbers to your Excel 2010 worksheet if there are a lot of pages, or if you think it is likely that the pages might become separated. But if your worksheet is part of a larger printed document, then it could be confusing to the reader if the page numbers […]

Printing an Excel spreadsheet can be difficult when the data that you have is not ideally suited for a piece of paper. It can be helpful to copy the top row to every page in Excel 2013 when your document is going to span multiple pages, but the method in that article can be a little […]