In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to print the lines between rows and columns to make reading easier (Microsoft Excel*)...
Tame your computer - read between the lines
In Excel, borders can add visual interest to a worksheet, as well as make the data easier to read. As you know, the lines that you see between the rows and columns don't appear when you print the worksheet.
You can obviously add borders around the cells, but did you know that there is a very simple and quick way to make the gridlines appear in your printed worksheets?
- Select the sheet(s) you want to print.
- On the Page Layout tab, in the Sheet Options group, tick the Print check box.
The gridlines will only be printed if the cell contains data. If you want to print gridlines around empty cells, you must set a print area to include those cells.
- Select the cells including the empty cells you want to print the gridlines of.
- On the Page Layout tab, click on the Print Area button and select Set Print Area.
By the way, both the Print Gridlines as well as Print Area settings are saved along with your workbook, so you might at some point want to clear the options.
And finally, any borders that you added manually will be printed instead of the gridlines.
* Unless stated otherwise, these tips were written for Microsoft Office 2010.
10 October 2016
Roem Ltd is a Learning Collaboration approved supplier, having come recommended by Cambridge Network member organisations. Network membership means you automatically have the right to book on to any LC course at any time, while some categories of membership actually include LC training units.