Help!

Printing a blank spreadsheet

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Default Always Changes  
Author Message
AlliKat
External


Since: Feb 03, 2009
Posts: 1



PostPosted: Tue Feb 03, 2009 5:01 pm    Post subject: Printing a blank spreadsheet
Archived from groups: microsoft>public>excel>misc (more info?)

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
Back to top
Mike H
External


Since: May 24, 2006
Posts: 1182



PostPosted: Tue Feb 03, 2009 5:15 pm    Post subject: RE: Printing a blank spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Khoshravan
External


Since: Jan 30, 2009
Posts: 18



PostPosted: Tue Feb 03, 2009 5:49 pm    Post subject: RE: Printing a blank spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Don Guillett
External


Since: Jan 04, 2006
Posts: 3013



PostPosted: Tue Feb 03, 2009 7:08 pm    Post subject: Re: Printing a blank spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@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
Back to top
Bob I
External


Since: Dec 30, 2004
Posts: 633



PostPosted: Tue Feb 03, 2009 7:14 pm    Post subject: Re: Printing a blank spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum