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

Excel

ResolvedVersion 2007

Fri 20 Mar 2009, 16:17 Delegate Stacey said...

Stacey has attended:
Excel Intermediate course

Excel

How can I view all the information on a spreadsheet

Tue 24 Mar 2009, 10:43 Trainer Cress said...

RE: Excel

Hello Stacey
Thank you for your question

If your spreadsheet is really huge, you may not be able to view it all at the same time as it may come up too small, but have you tried going to View menu and choosing Page break preview instead of normal?

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 31 Mar 2009: Automatically marked as resolved.

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

Excel

Excel

RE: Excel

Excel articles

Excel tip:

New Normal Worksheet