ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   a stupid basic format question (https://www.excelbanter.com/excel-discussion-misc-queries/125100-stupid-basic-format-question.html)

Yiddy

a stupid basic format question
 
This will probably seem like areally sijmple question to most Excel users,
but I don't know the answer. When I create a spreadsheet in Excel, of course
all the cells are divided by lines, but when I print it out, the lines are no
longer there. How do I keep the separation lines in the spreadsheet when I
print it?
Thanks.
--
Yiddy

JMB

a stupid basic format question
 
Click File/Page Setup/Sheet and check Print Gridlines.

Or, you can add your own borders. Click Format/Cells/Borders or use the
borders button on the Formatting toolbar. If the toolbar isn't visible,
click View/Toolbars/Formatting.


"Yiddy" wrote:

This will probably seem like areally sijmple question to most Excel users,
but I don't know the answer. When I create a spreadsheet in Excel, of course
all the cells are divided by lines, but when I print it out, the lines are no
longer there. How do I keep the separation lines in the spreadsheet when I
print it?
Thanks.
--
Yiddy


Nick Hodge

a stupid basic format question
 
Yiddy

If you haven't added a colour to the cell then FilePage
setupsheetgridlines

If you've applied a colour, you'll need to add a border around all the cells
as this will overwrite the built-in lines

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Yiddy" wrote in message
...
This will probably seem like areally sijmple question to most Excel users,
but I don't know the answer. When I create a spreadsheet in Excel, of
course
all the cells are divided by lines, but when I print it out, the lines are
no
longer there. How do I keep the separation lines in the spreadsheet when I
print it?
Thanks.
--
Yiddy




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

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