Excel for Marketing Managers

Printing Grid Paper

Printing
Grid Paper

Using the Application.................................................................................................................

Even though you will be drawing gridlines, Excel expects there to be something

inside of the cells. When you later try to print or use Print Preview, Excel will

complain that there is nothing to print.

To prevent this objection from Excel, enter a single spacebar character in cell

A1 of the spreadsheet.

Adding Gridlines

In order to print the grid paper, you will have to either turn on gridlines or add

borders to the cells. It is easier to turn on gridlines (see Formatting with

Gridlines on page 26) but you have more control when you use borders.

Formatting with Cell Borders

1. Open the Format Cells dialog box.
   While you have all cells selected, type Ctrl+1 (in case it is hard to read in
   this font, that is the numeric “one” key while you are holding down the Ctrl
   key). Ctrl+1 is the shortcut to display the Format Cells dialog box.


2. Format the border.
   The Format Cells dialog has six tabs across the top. Choose the Border tab.

Figure 42

Prompt indicating nothing

to print