Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » New Normal Worksheet
New Normal Worksheet
Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)
Note: These changes are permanent changes on your PC.
Added by Pete on 7th March 2007
More Excel hints and tips, like:
- How to select certain data in an Excel 2010 workbook
- Do a fast scroll
- The dual nature of toolbar buttons
 |
|
» Forum post: Excel Statrup |
How can I stop Excel opening 'Book1' when I open Excel - this happens either when opening just the application or when I open a file to start the application.
