Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Gridlines
I would like to make a template with the top 1/3 of the sheet blank and the
the rest with gridlines when I print the page. How do I do this? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Gridlines
Hi aceman
Start by going to menu ToolsOptionsunselect Gridline, now highlight the range you want to have gridline and goto Format Cells Borders and create your gridline. HTH John "aceman" wrote in message ... I would like to make a template with the top 1/3 of the sheet blank and the the rest with gridlines when I print the page. How do I do this? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Gridlines
The thin pale gridlines taht you see on the screen will not print out, so
that is how you produce the blank part of the sheet - to print grid lines on the rest of the sheet - hight light the area where you want the lines and Format Cells Border (tab) and select Outline then inside OK Hope this helps "aceman" wrote: I would like to make a template with the top 1/3 of the sheet blank and the the rest with gridlines when I print the page. How do I do this? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Gridlines
Select the cells in the top 1/3 of the sheet and Format them to White
Background. No, they are "not" already white.............they are "no color". The gridlines will be hidden. Gord Dibben MS Excel MVP On Fri, 13 Feb 2009 05:29:01 -0800, aceman wrote: I would like to make a template with the top 1/3 of the sheet blank and the the rest with gridlines when I print the page. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gridlines are there, then Custom View, gridlines disappear in xl 2 | Excel Discussion (Misc queries) | |||
not all the gridlines print; despite selecting/"gridlines" | Excel Discussion (Misc queries) | |||
Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
No Gridlines | Excel Worksheet Functions |