K
kenw100
I know this a very basic question, but I can't find the
answer! How do I change the print setup defaults in
Excel?
answer! How do I change the print setup defaults in
Excel?
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.
G
Gord Dibben
A little too basic.
There are some defaults that can be altered by setting up a workbook as you
wish then saving it as a New Workbook Template or as a New Worksheet Template.
Post back with more specific needs.
Gord Dibben Excel MVP - XL97 SR2 & XL2002
There are some defaults that can be altered by setting up a workbook as you
wish then saving it as a New Workbook Template or as a New Worksheet Template.
Post back with more specific needs.
Gord Dibben Excel MVP - XL97 SR2 & XL2002
G
Gord Dibben
Ken
Unfortunately most print settings are worksheet-specific and cannot be set as
a default globally.
You can set up a workbook with one worksheet as you wish then File>Save
As>Type Template(*.xlt)
Name it SHEET and save it to your Office\XLSTART folder. When you select
Insert>Worksheet this is the sheet that will be inserted with your print
settings.
If you want this to also be the default workbook, save as again as BOOK to
XLSTART folder.
Note: Excel will add the .XLT extension in both cases after you have selected
the Save As Type.
An alternate method would involve a VBA macro stored in your Personal.xls
file. Assign it to a button which you can click to run the macro which sets
up your print settings. Could be designed to set all worksheets the same or
just one at a time.
For existing workbooks you can "group" worksheets by right-clicking on a sheet
tab and "select all sheets". Do your print setup on the active sheet and all
sheets will be affected.
DO NOT FORGET to right-click again to "ungroup" sheets. What you do to one
will be done to all.
Gord Dibben Excel MVP - XL97 SR2 & XL2002
Unfortunately most print settings are worksheet-specific and cannot be set as
a default globally.
You can set up a workbook with one worksheet as you wish then File>Save
As>Type Template(*.xlt)
Name it SHEET and save it to your Office\XLSTART folder. When you select
Insert>Worksheet this is the sheet that will be inserted with your print
settings.
If you want this to also be the default workbook, save as again as BOOK to
XLSTART folder.
Note: Excel will add the .XLT extension in both cases after you have selected
the Save As Type.
An alternate method would involve a VBA macro stored in your Personal.xls
file. Assign it to a button which you can click to run the macro which sets
up your print settings. Could be designed to set all worksheets the same or
just one at a time.
For existing workbooks you can "group" worksheets by right-clicking on a sheet
tab and "select all sheets". Do your print setup on the active sheet and all
sheets will be affected.
DO NOT FORGET to right-click again to "ungroup" sheets. What you do to one
will be done to all.
Gord Dibben Excel MVP - XL97 SR2 & XL2002
I would always like to check the center "horizontal",
reduce the margins, and always have gridlines print. I
use Excel 2000. Thanks for your help!
Ken
D
Dave Peterson
Create a new workbook with the print setup set exactly the way you want. Now
save that as book.xlt in your xlstart folder (save it as a template, too.)
Every new workbook will inherit the settings from this workbook.
If you create another workbook (single sheet usually) with those print settings
the way you want, you can name it sheet.xlt. Store it in xlstart, too. Then
every new worksheet added to an existing workbook will inherit those settings.
save that as book.xlt in your xlstart folder (save it as a template, too.)
Every new workbook will inherit the settings from this workbook.
If you create another workbook (single sheet usually) with those print settings
the way you want, you can name it sheet.xlt. Store it in xlstart, too. Then
every new worksheet added to an existing workbook will inherit those settings.
I would always like to check the center "horizontal",
reduce the margins, and always have gridlines print. I
use Excel 2000. Thanks for your help!
Ken