Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
The grid in printed documentsPosted by Rony Verhulst on May 10, 2001 11:29 PM
Everytime I print an Excel document I have to manualy put on the grid. Is there a way to do this permanently
Thanks for your help!
Re: The grid in printed documentsPosted by Tim on May 11, 2001 4:14 AM
Hopefully this should work;
This is just following the 'create workbook template for new workbooks help'
Open up excel, and go straight to file/page setup and select print gridlines, add nothing else to the spreadsheet.
Now save the file but as a template in the XLStart folder, ususally found at;
Now close Excel completely, when you restart, it will look for this template file and your gridlines should be set.
Re: The grid in printed documentsPosted by Ed on May 11, 2001 4:17 AM
On the sheet you want the grid to print, go to File/Print Preview/Setup. Select the Sheet tab on the dialog box and then select Gridlines under the Print option.
Hope it helped.
Re: The grid in printed documentsPosted by Rony on May 11, 2001 4:36 AM
Hi Ed & Tim
Thanks for your help. This was a problem for a friend of mine. In a couple of days i will meet hem and explain him what to do.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.