ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 grid printing (https://www.excelbanter.com/excel-discussion-misc-queries/104380-excel-2003-grid-printing.html)

JJ

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

Gord Dibben

Excel 2003 grid printing
 
Not sure what you are asking here.

To print gridlines, FilePage SetupSheet.

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

On Thu, 10 Aug 2006 16:17:01 -0700, JJ wrote:

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



Terre

Excel 2003 grid printing
 
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?

"Gord Dibben" wrote:

Not sure what you are asking here.

To print gridlines, FilePage SetupSheet.

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

On Thu, 10 Aug 2006 16:17:01 -0700, JJ wrote:

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




Gord Dibben

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

How did you get there?

FilePage Setup is where you want to be.

You will see four tabs.

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

Alternative way in..........ViewHeader and Footer. See the four tabs?


Gord


On Tue, 19 Sep 2006 12:55:02 -0700, Terre
wrote:

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?

"Gord Dibben" wrote:

Not sure what you are asking here.

To print gridlines, FilePage SetupSheet.

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

On Thu, 10 Aug 2006 16:17:01 -0700, JJ wrote:

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






All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com