ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to set DEFAULT print options in Excel to print gridlines? (https://www.excelbanter.com/excel-discussion-misc-queries/46919-how-set-default-print-options-excel-print-gridlines.html)

LKR

How to set DEFAULT print options in Excel to print gridlines?
 
I would like to set the default page setup to print gridlines so I don't have
to go tell it to print the gridlines every time I do a new document. Any way
to do that?
Thanks!

Chip Pearson

Create a template called Book.xlt with the default settings you
desire. Store this file in the XLStart folder (typically
C:\Program Files\Microsoft Office\Office\XLStart ). This template
will be used to create any new workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"LKR" wrote in message
...
I would like to set the default page setup to print gridlines so
I don't have
to go tell it to print the gridlines every time I do a new
document. Any way
to do that?
Thanks!





All times are GMT +1. The time now is 03:51 AM.

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