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.

Hi Jim,
Go to Page Layout, Page setup, Print Titles, in the middle of the page setup
check in the print area Gridlines

"Jim" wrote:

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.

Hi,
Go to Page Layout, sheet options, 4th option to your right, and where it
says gridlines check where it says print

"Jim" wrote:

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.


"Eduardo" wrote:

Hi Jim,
Go to Page Layout, Page setup, Print Titles, in the middle of the page setup
check in the print area Gridlines

"Jim" wrote:

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.

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.


"Eduardo" wrote:

Hi Jim,
Go to Page Layout, Page setup, Print Titles, in the middle of the page setup
check in the print area Gridlines

"Jim" wrote:

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.

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.

"Eduardo" wrote:

Hi,
Go to Page Layout, sheet options, 4th option to your right, and where it
says gridlines check where it says print

"Jim" wrote:

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.


"Eduardo" wrote:

Hi Jim,
Go to Page Layout, Page setup, Print Titles, in the middle of the page setup
check in the print area Gridlines

"Jim" wrote:

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.

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.

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


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 08:49:38 -0800, Jim
wrote:

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.

"Eduardo" wrote:

Hi,
Go to Page Layout, sheet options, 4th option to your right, and where it
says gridlines check where it says print

"Jim" wrote:

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.


"Eduardo" wrote:

Hi Jim,
Go to Page Layout, Page setup, Print Titles, in the middle of the page setup
check in the print area Gridlines

"Jim" wrote:

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.

Thank you Gord. I wanted to make sure I didn't overlook an option - and
sounds like I didn't.

"Gord Dibben" wrote:

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.

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


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 08:49:38 -0800, Jim
wrote:

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.

"Eduardo" wrote:

Hi,
Go to Page Layout, sheet options, 4th option to your right, and where it
says gridlines check where it says print

"Jim" wrote:

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.


"Eduardo" wrote:

Hi Jim,
Go to Page Layout, Page setup, Print Titles, in the middle of the page setup
check in the print area Gridlines

"Jim" wrote:

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.