Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke Bailey
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set view page breaks as a default. mncm Excel Worksheet Functions 3 March 24th 09 10:12 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
How do I change default settings to page break preview Jimbo693 Setting up and Configuration of Excel 1 April 1st 05 06:51 PM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
How do I change the default settings in charts? drahcir Charts and Charting in Excel 1 December 14th 04 11:30 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"