A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I get the vertical and horizontal lines when I print



 
 
Thread Tools Display Modes
  #1  
Old January 19th, 2004, 01:24 PM
linda99
external usenet poster
 
Posts: n/a
Default How do I get the vertical and horizontal lines when I print

I am very new at Excel (how can you tell!!) - how do I get the horizontal and vertical
lines that are on the screen to print onto the paper. Thanks in advance for any help you can give me.
  #2  
Old January 19th, 2004, 01:44 PM
Paul
external usenet poster
 
Posts: n/a
Default How do I get the vertical and horizontal lines when I print

"linda99" wrote in message
...
I am very new at Excel (how can you tell!!) - how do I get the horizontal

and vertical
lines that are on the screen to print onto the paper. Thanks in advance

for any help you can give me.

File Page Setup Sheet tab
Check "Print, Gridlines".


  #3  
Old January 19th, 2004, 01:45 PM
JMay
external usenet poster
 
Posts: n/a
Default How do I get the vertical and horizontal lines when I print

Under Print, Page Setup, Sheet Tab; look for Gridlines (and Check it).

"linda99" wrote in message
...
I am very new at Excel (how can you tell!!) - how do I get the horizontal

and vertical
lines that are on the screen to print onto the paper. Thanks in advance

for any help you can give me.


  #4  
Old January 19th, 2004, 02:33 PM
linda99
external usenet poster
 
Posts: n/a
Default How do I get the vertical and horizontal lines when I print

Thanks for the answers, now know how to do it!!



linda99 wrote:

I am very new at Excel (how can you tell!!) - how do I get the horizontal and vertical
lines that are on the screen to print onto the paper. Thanks in advance for any help you can give me.

  #5  
Old January 19th, 2004, 04:08 PM
linda99
external usenet poster
 
Posts: n/a
Default How do I get the vertical and horizontal lines when I print Part II

Oops, I do still have another question.
I want to print off a form with only headings, and
then I am going to fill in the form daily with pen.

When I did what you explained, all I got was the
headings nicely lined, but nothing else, how do I get
rows of lines and columns that I can fill in. Thanks again.

JMay wrote:

Under File, Page Setup, Sheet Tab; look for Gridlines (and Check it).

"linda99" wrote in message
...
I am very new at Excel (how can you tell!!) - how do I get the horizontal

and vertical
lines that are on the screen to print onto the paper. Thanks in advance

for any help you can give me.

  #6  
Old January 20th, 2004, 01:15 PM
JMay
external usenet poster
 
Posts: n/a
Default How do I get the vertical and horizontal lines when I print Part II

From your response and to achieve what it sounds like you want, I'd set up
the form design using the Borbers toolbar or for more control use from the
menu, Format, Cells, Border tab. Extending Column Widths to accommodate
your write in areas, etc. Once you do this Save -It. You may then want to
disable the Gridlines previously mentioned (on the Sheet tab of Page Setup)
as these (Gridlines) will ADD to the left and above of all blank cells in
the Printed Range, (which I don't think you want done).
HTH

"linda99" wrote in message
...
Oops, I do still have another question.
I want to print off a form with only headings, and
then I am going to fill in the form daily with pen.

When I did what you explained, all I got was the
headings nicely lined, but nothing else, how do I get
rows of lines and columns that I can fill in. Thanks again.

JMay wrote:

Under File, Page Setup, Sheet Tab; look for Gridlines (and Check it).

"linda99" wrote in message
...
I am very new at Excel (how can you tell!!) - how do I get the

horizontal
and vertical
lines that are on the screen to print onto the paper. Thanks in

advance
for any help you can give me.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.