Forum home » Delegate support and help forum » Microsoft Excel Training and help » Templates

Templates

ResolvedVersion 2003

Thu 31 Jul 2008, 16:37 Delegate Alan said...

Alan has attended:
Excel Intermediate course

Templates

Can a protected template be created in such away as to not look like a spreadsheet.

Fri 1 Aug 2008, 07:06 Trainer Pete said...

RE: Templates

Hi Alan, Thank you for your post and welcome to the forum,
In answer to your question: Excel will always have cells, columns and rows, but how you choose to use (disguise) them depends very much on formatting and arrangement of Boilerplate text and input cells.
Check out the pre-created templates on your computer or on Microsoft Online to see just what can be achieved.
regards Pete

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Templates

Templates

RE: Templates

Excel articles

Excel tip:

New Normal Worksheet