how do u print out a spreadhseet with the lines?
thankss
You need to put borders for it.
You can find this as an small icon on the tool bar of the Excel sheet.
Hi
In most versions of Excel it's
File > Page Setup
click on the Sheet Tab
click the checkbox next to Gridlines
In Excel 2007 it's different
Click Page Layout
in the Sheet Options compartment
Under Gridlines click the check box next to Print
-Jim Gordon
http://360.yahoo.com/profile-i7JMeio7cqvhotIUwCzaJ...
Just add borders to the lines. Do this through the Format Cells option, or use the key on the toolbar. Only add them to the range you are using, or you might end up printing a whole lot of paper with lines on it...
The line what u see in excel are just for your referemce, if u want them in ur print you need to draw lines as you need them to look in ur print.
you can use the below option.
e.g: you want to draw lines betwen rows and column to represent it as a table.
- select the entire table by dragging ur mouse then use tool called DRAW BORDER, it has various ways in which you can draw border to that selection.
it is the tollbutton next to FILL COLOR or FILL Text toll button
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
Verified answer
You need to put borders for it.
You can find this as an small icon on the tool bar of the Excel sheet.
Hi
In most versions of Excel it's
File > Page Setup
click on the Sheet Tab
click the checkbox next to Gridlines
In Excel 2007 it's different
Click Page Layout
in the Sheet Options compartment
Under Gridlines click the check box next to Print
-Jim Gordon
http://360.yahoo.com/profile-i7JMeio7cqvhotIUwCzaJ...
Just add borders to the lines. Do this through the Format Cells option, or use the key on the toolbar. Only add them to the range you are using, or you might end up printing a whole lot of paper with lines on it...
The line what u see in excel are just for your referemce, if u want them in ur print you need to draw lines as you need them to look in ur print.
you can use the below option.
e.g: you want to draw lines betwen rows and column to represent it as a table.
- select the entire table by dragging ur mouse then use tool called DRAW BORDER, it has various ways in which you can draw border to that selection.
it is the tollbutton next to FILL COLOR or FILL Text toll button