Excel for Marketing Managers

(Dana P.) #1

Printing Grid Paper


Printing
Grid Paper

b. If you scroll down several rows, you will eventually see a darker hori-
zontal line around row 59. This is the bottom of the printed page.


  1. Set the print area.
    As mentioned previously, Excel looks at all of these seemingly empty cells
    and is not sure why you would want to print them. You need to explicitly
    tell Excel to print the entire page of borders.


a. In the preceding images, the last cell on the first page is AN59. Earlier
in this section, you entered a single spacebar character in cell A1. Now,
you need to select cell AN59 and enter a single spacebar in that cell.

b. Finally, make sure that you don’t print more than one page. Click in
cell AN59 and drag up to cell A1 to select the range of A1:AN59. With
this range selected, go to the File menu and select Print Area → Set
Print Area.

Figure 53
Dotted horizontal line shows bottom border of page
Free download pdf