J
Jim
In Excel 2007, is there an option I can set to have gridlines print as the
default? I've not been able to find that option.
default? I've not been able to find that option.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eduardo
Hi Jim,
Go to Page Layout, Page setup, Print Titles, in the middle of the page setup
check in the print area Gridlines
Go to Page Layout, Page setup, Print Titles, in the middle of the page setup
check in the print area Gridlines
E
Eduardo
Hi,
Go to Page Layout, sheet options, 4th option to your right, and where it
says gridlines check where it says print
Go to Page Layout, sheet options, 4th option to your right, and where it
says gridlines check where it says print
J
Jim
Thanks for the tip Eduardo, but that didn't set the default. I still have to
select "Print Gridlines" before they will print. I want to set that option
as a default. I just can't find the right button to do that in Excel 2007.
select "Print Gridlines" before they will print. I want to set that option
as a default. I just can't find the right button to do that in Excel 2007.
J
Jim
Hi Eduardo,
Well that works on the worksheet I have currently open, but when I open a
different worksheet - say after i close and reopen Excel - the gridlines
aren't there.
Well that works on the worksheet I have currently open, but when I open a
different worksheet - say after i close and reopen Excel - the gridlines
aren't there.
G
Gord Dibben
Printing gridlines is not a global setting and must be set for each sheet.
You could create a new default workbook template that would have the setting
but only for new workbooks.
Open a new workbook. Customize as you wish.
File>Save 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 File>New or the Toolbar button
File>New or CTRL + n
WARNING................Do not use File>New...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 Insert>Sheet.
More can be found on this in Help under "templates"(no quotes).
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
You could create a new default workbook template that would have the setting
but only for new workbooks.
Open a new workbook. Customize as you wish.
File>Save 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 File>New or the Toolbar button
File>New or CTRL + n
WARNING................Do not use File>New...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 Insert>Sheet.
More can be found on this in Help under "templates"(no quotes).
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
J
Jim
Thank you Gord. I wanted to make sure I didn't overlook an option - and
sounds like I didn't.
sounds like I didn't.