MrExcel Publishing
Your One Stop for Excel Tips & Solutions

The grid in printed documents


Posted 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!


Posted 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;
C:\windows\application data\microsoft\excel\xlstart.

Now close Excel completely, when you restart, it will look for this template file and your gridlines should be set.

Tim

Posted by Ed on May 11, 2001 4:17 AM

Rony,

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.

Ed

Posted 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.
Thanks.