Printing a blank spreadsheet

AlliKat · External Since: Feb 03, 2009 Posts: 1

Can you print a blank spreadsheet with the gridlines and headings only? I
have a spreadsheet that I have the headings in the cells at the top. That is
all I need. But when I try to print and check gridlines on my sheet page, it
still only prints out my column headings? Or is Excel the best place to do
this?
Thank you,
AlliKat

Mike H · External Since: May 24, 2006 Posts: 1182

Hi,

Select the area you want to print including your headings and then

File|Print area - Set print area

Then

File|Page setup - Sheet tab and check 'Gridlines' OK

Is Excel the best place to do it? Maybe, but consider a table in Word.

Mike

"AlliKat" wrote:

> Can you print a blank spreadsheet with the gridlines and headings only? I
> have a spreadsheet that I have the headings in the cells at the top. That is
> all I need. But when I try to print and check gridlines on my sheet page, it
> still only prints out my column headings? Or is Excel the best place to do
> this?
> Thank you,
> AlliKat

Khoshravan · External Since: Jan 30, 2009 Posts: 18

Don't remember to check the following if you want to print the grid lines as
well:
File| Page setup| Sheet under Print select: Gridlines, otherwise they will
not be printed.

--
R. Khoshravan
Please click "Yes" if it is helpful.

"AlliKat" wrote:

> Can you print a blank spreadsheet with the gridlines and headings only? I
> have a spreadsheet that I have the headings in the cells at the top. That is
> all I need. But when I try to print and check gridlines on my sheet page, it
> still only prints out my column headings? Or is Excel the best place to do
> this?
> Thank you,
> AlliKat

Don Guillett · External Since: Jan 04, 2006 Posts: 3013

select the last cell to print and touch the space bar>print

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1.TakeThisOut@austin.rr.com
"AlliKat" wrote in message

> Can you print a blank spreadsheet with the gridlines and headings only? I
> have a spreadsheet that I have the headings in the cells at the top. That
> is
> all I need. But when I try to print and check gridlines on my sheet page,
> it
> still only prints out my column headings? Or is Excel the best place to do
> this?
> Thank you,
> AlliKat

Bob I · External Since: Dec 30, 2004 Posts: 633

Select the area to be printed out and then Set Print Area

AlliKat wrote:

> Can you print a blank spreadsheet with the gridlines and headings only? I
> have a spreadsheet that I have the headings in the cells at the top. That is
> all I need. But when I try to print and check gridlines on my sheet page, it
> still only prints out my column headings? Or is Excel the best place to do
> this?
> Thank you,
> AlliKat