Tame your computer – read between the lines

14 Oct

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?

Here’s how:

  1. Select the sheet(s) you want to print.
  2. 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.

  1. Select the cells including the empty cells you want to print the gridlines of.
  2. 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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: