![]() |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com