Forum home »
Delegate support and help forum »
Microsoft Excel VBA Training and help » Test
Test
Resolved · Low Priority · Version 2003
Reply Fri 14 Aug 2009, 16:21Delegate Vishal said...
|
Please browse our web site to find out more about
excel consultant and other Microsoft training courses. |
Excel tip:
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.
View all Excel hints and tips
|
|