If you really only use one sheet and not the default three that Excel creates with any new workbook you can customise this to suit your way of working. Change Excel’s default settings by going to the File menu > Options > General. Look in the section ‘When creating new workbooks’ and change ‘Include this […]
Recovering unsaved workbooks – Excel 2010
Mistakenly closed a workbook without saving? You can sometimes recover your work in Excel 2010. Go to File, Info, click the Manage Versions button and select Recover Unsaved Workbooks. Excel 2010 automatically keeps a copy of many (but not all) unsaved workbooks for a few days.
Excel Spell Check
Spell check all worksheets in an Excel file. Right-click on one of the worksheet tabs. This will open a quick menu from which you can choose ‘Select All Sheets’. Press the function key F7 to begin the spell check.
Highlight All Cells Referenced by a Formula
Excel 2010. To highlight all the cells referenced by a formula press Ctrl+[ (that’s Ctrl and open-square-bracket). The current selection will also move to the first of the referenced cells. Press Enter, and the selection moves to the next referenced cell, continue to press Enter to move though the rest of the referenced cells.
Custom format a telephone number
Want to format a phone number? Use Ctrl+1 to bring up the Format Cells dialog box. In the Type: text box enter (+00) 000 000 0000 for 2 digit country codes.
Quickly Sum Non-Contiguous Cells
Click the AutoSum button. Then, one at a time, click each of the cells you want to sum, typing a comma to separate each cell in the formula (e.g. =SUM(C8,D10,F8,H8,J8). Another option is to hold down the CTRL key (instead of typing the comma) as you are selecting the cells. You can also drag to […]
Quick Navigation
When you press the Ctrl key combined with any arrow key (north, east, south, or west), you jump to the last populated cell in that direction.
Repeat Action
To repeat the last action that you’ve just taken, select a cell or a range of cells where you want to repeat it and press the function key – F4. You can repeat this over and over.
Today’s Date
To insert Today’s date use Ctrl+; (semicolon) on the keyboard.
Cell Navigation
To move through a group of cells that you’re working on (without going outside the range) highlight the group of cells and then use the “Enter” key to move through them.