Excel 2003 grid printing

J

JJ

How do you print in Excel 2003 just to show the grid of the cell; i.e. A5,
A6, and so on.
 
G

Gord Dibben

Not sure what you are asking here.

To print gridlines, File>Page Setup>Sheet.

Checkmark "gridlines" under the Print section.

If you want to print a blank range with just the gridlines, Excel needs
something to print.

You must enter a space in a cell at the bottom right corner of a range say
A1:K45

Enter the space in K45.


Gord Dibben MS Excel MVP
 
T

Terre

There is no 'sheet' tab under page setup in my version of 2003. The tabs are
Margins, Paper, Layout. The option is not displayed in Layout. I've been
looking for the 'gridlines' box to select for an hour. Any clue where I
might find that option?
 
G

Gord Dibben

Margins, Paper, Layout tabs are the tabs found under "Options" for your Printer
setup.

How did you get there?

File>Page Setup is where you want to be.

You will see four tabs.

Page.........Margins.........Header/Footer..........Sheet

Alternative way in..........View>Header and Footer. See the four tabs?


Gord
 
Top