Tip # 42 See the big picture

If you’re working on a large sheet you might want to switch to Full Screen mode: simply click on View, Full Screen. Click on it again to return to a normal window.

Tip # 41 Find the currently active cell

If you’ve been scrolling around your spreadsheet and you lose your place, you can jump back to the currently active cell by pressing the [Ctrl] + [Backspace] keys.

Tip # 40 Enter a fixed time into Excel

If you want Excel to enter the current date or time and fix it at that point – for example, to show the last date the sheet was modified – click on a cell and press [Ctrl] + [;] for the date and [Ctrl] + [:] for the time.

Tip # 39 A quick way to enter the time

To enter the current date or time click on a cell and type =today() or =now().Excel updates the result every time you open the sheet, so it’s always current.

Tip # 38 Use the AutoCalculator

If you need to calculate a sum based on a row or a column of figures and you can’t be bothered typing in a function, just select your figures and glance down at the status bar – you’ll find the sum of the selected cells there.

What’s more, if you right-click on the sum a pop-up menu will appear offering additional quick calculation functions.