Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 default to printing gridlines
In Excel 2002, is there any way to set a default so that gridlines print
without having to go into the page setup for every spreadsheet? Thanks, Bruce |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 default to printing gridlines
Open a new workbook. Customize as you wish including your print
settings.........group the sheets before setup so's all sheets get same setup. FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for FileNew or the Toolbar button FileNew or CTRL + n WARNING................Do not use FileNew...Blank Workbook or you will get the Excel default workbook. NOTE: Existing workbooks are not affected by these settings. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default InsertSheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 13:07:02 -0800, Brucels wrote: In Excel 2002, is there any way to set a default so that gridlines print without having to go into the page setup for every spreadsheet? Thanks, Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel gridlines not printing | Excel Discussion (Misc queries) | |||
set gridlines to print by DEFAULT in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2002...adding back gridlines to imported file | New Users to Excel | |||
Excel should let me set print gridlines as a default | Excel Worksheet Functions | |||
Can I set gridlines in excel as a default setting? How? | Excel Discussion (Misc queries) |