Using Excel 2007

Views

You can change the View in Excel  using the View Category, or if you are using the mouse, there are buttons on the Status bar to do this. The most commonly used Views are Normal, Page Layout and Page Break Preview. 
To choose the Normal View, press Alt+W, L.
To change to Page Break, press Alt+W, I.

New workbook

Press Ctrl+N to open a new blank workbook.

Excel Options

You can customise Excel using the Options dialog box. As mentioned in a previous note this is accessed in Office 2007 using the Office menu. Press Alt+F,I to open Excel Options. You are now in a list of several different categories of options: Popular, Formulas, Proofing, Save, Advanced etc. Choose the category using the arrow keys. The category shown to the right changes as you navigate in this list. When you are on the desired category you can then use Tab to navigate to the option you wish to change.

Settings

Zoom

The zoom function is found in the View category. Press Alt+W,Q to open the Zoom dialog box and choose the required magnification using the arrow keys and press Enter.

Freeze, unfreeze row and/or column titles.

To freeze a row or column place the cursor in the row, column you wish to freeze. Choose View, Freeze panes. Or press Alt+W, F and choose Freeze row or column from the submenu.

To unfreeze place the cursor in the row, column you wish to unfreeze. Choose View, Freeze panes. Or press Alt+W, F and choose unfreeze pane from the submenu.

Navigation

The navigation keys are in general the same as in previous Excel versions:

Ctrl+Home Moves to the first cell in the spreadsheet
Ctrl+End Moves to the last cell with content in the spreadsheet
Ctrl+F Find content
Ctrl+G Go to, here you can type in the cell reference you want to move to, as in previous versions.

Sort

Place the cursor in the column to be sorted. Choose Alt+H, S and choose the Sort order.

Del på Facebook Del på Twitter Del på e-post