ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing a blank spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/218965-printing-blank-spreadsheet.html)

AlliKat

Printing a blank spreadsheet
 
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

Printing a blank spreadsheet
 
select the last cell to print and touch the space barprint

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

Printing a blank spreadsheet
 
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



Mike H

Printing a blank spreadsheet
 
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

Printing a blank spreadsheet
 
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



All times are GMT +1. The time now is 05:29 PM.

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