Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Catz
 
Posts: n/a
Default how can i change default settings for spreadsheets

eg margins, footers, etc
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default how can i change default settings for spreadsheets

Catz, here is a post from Gord Dibben on the subject,

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 FileNewWorkbook.

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 Excel MVP

"Catz" wrote in message
...
eg margins, footers, etc



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
Change Excel Defualt Settings Cillian Excel Discussion (Misc queries) 0 April 26th 06 05:14 PM
Can I change my default paste settings? Sly Excel Discussion (Misc queries) 4 March 10th 06 09:16 PM
How to change default printing parameters on Excel & ...... Amjad Excel Discussion (Misc queries) 9 September 7th 05 03:22 PM
How can I change the default settings for pivot tables in Excel? . KyWilde Excel Discussion (Misc queries) 0 March 9th 05 11:33 PM
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 02:20 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"