ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Default Page Settings (https://www.excelbanter.com/excel-worksheet-functions/91485-default-page-settings.html)

Luke Bailey

Default Page Settings
 
Hello,
Is there a way to set default page settings for new workbooks? I would like
to have default margins different than the standard 1.0 inch for top and
bottom.

Marcelo

Default Page Settings
 
Hi,

create and record an spreadsheet called "personal.xls" on the startup folder
with the custom format that you would like to work.

normaly you can find it as
C:\program files\microsoft offece\office11\startup

OR

Create a template workbook and name it book.xlt and put it in the XLStart
folder.

Each time you click on the new icon on the standard toolbar, that new workbook
will inherit all the settings from that template file.

Regards from Brazil
Marcelo



"Luke Bailey" escreveu:

Hello,
Is there a way to set default page settings for new workbooks? I would like
to have default margins different than the standard 1.0 inch for top and
bottom.


Dave Peterson

Default Page Settings
 
The personal.xls file is useful for things like common macros that the user
wants available when excel starts. But it's not used for storing these kinds of
page layouts/formatting.

But book.xlt would work nicely.

Marcelo wrote:

Hi,

create and record an spreadsheet called "personal.xls" on the startup folder
with the custom format that you would like to work.

normaly you can find it as
C:\program files\microsoft offece\office11\startup

OR

Create a template workbook and name it book.xlt and put it in the XLStart
folder.

Each time you click on the new icon on the standard toolbar, that new workbook
will inherit all the settings from that template file.

Regards from Brazil
Marcelo

"Luke Bailey" escreveu:

Hello,
Is there a way to set default page settings for new workbooks? I would like
to have default margins different than the standard 1.0 inch for top and
bottom.


--

Dave Peterson

Marcelo

Default Page Settings
 
Dave, thanks for the feedback

regards

Marcelo

"Dave Peterson" escreveu:

The personal.xls file is useful for things like common macros that the user
wants available when excel starts. But it's not used for storing these kinds of
page layouts/formatting.

But book.xlt would work nicely.

Marcelo wrote:

Hi,

create and record an spreadsheet called "personal.xls" on the startup folder
with the custom format that you would like to work.

normaly you can find it as
C:\program files\microsoft offece\office11\startup

OR

Create a template workbook and name it book.xlt and put it in the XLStart
folder.

Each time you click on the new icon on the standard toolbar, that new workbook
will inherit all the settings from that template file.

Regards from Brazil
Marcelo

"Luke Bailey" escreveu:

Hello,
Is there a way to set default page settings for new workbooks? I would like
to have default margins different than the standard 1.0 inch for top and
bottom.


--

Dave Peterson



All times are GMT +1. The time now is 08:26 AM.

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