1.  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.

2. 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.

3. 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.

4.  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.

5. Fit text automatically
Make your work look neater by selecting the relevant column, and clicking on Format, Column, AutoFit Selection.
6. Fast copy, no clipboard
Pressing [Ctrl] + [‘] is a speedy way to duplicate the formula or figure in the cell above the one you’re in.

7. Fast and easy multiple entry
If you need to enter a formula in several cells at once, simply select all the target cells, type your formula as normal and press [Ctrl] + [Enter].
8. Pick cells for AutoCalculator
You can select unconnected cells by holding down [Ctrl] while you click on the individual cells.

9. Hide comments to reduce clutter
You can hide notes and other comments by using the Insert Comment function. Highlight a cell, click on Insert, Comment and type your text. Click
away from the input box when you’ve finished. The comment will appear whenever you pass your mouse over the relevant cell.

10. Re-colouring the grid lines
You can change the colour of the grid by clicking on Tools, Options…, selecting the View tab, clicking on the Color: list box and choosing a new colour from the palette. Choosing white
effectively removes the grid completely.

11. Angle your entries…
To make Excel display the text in cells at an angle of 45 degrees, right-click on the toolbar, select Chart, and pick either of the ab icons on the new toolbar.

12…to any degree you like
If you want custom angles right-click on the cell and select Format Cells… From the pop-up menu, click on the 17Fit text automatically Make your work look neater by selecting
the relevant column, and clicking on Format, Column, AutoFit Selection.

13.  Fast copy, no clipboard
Pressing [Ctrl] + [‘] is a speedy way to duplicate the formula or figure in the cell above the one you’re in.

14. Fast and easy multiple entry
If you need to enter a formula in several cells at once, simply select all the target cells, type your formula as normal and press [Ctrl] + [Enter].

15. Pick cells for AutoCalculator
You can select unconnected cells by holding down [Ctrl] while you click on the individual cells.

16. Hide comments to reduce clutter
You can hide notes and other comments by using the Insert Comment function.  Highlight a cell, click on Insert, Comment and type your text. Click away from the input box when you’ve finished. The comment will appear whenever you pass your mouse over the relevant cell.

17. Re-colouring the grid lines
You can change the colour of the grid by clicking on Tools, Options…, selecting the View tab, clicking on the
Color: list box and choosing a new colour from the palette. Choosing white effectively removes the grid completely.

18. Angle your entries…
To make Excel display the text in cells at an angle of 45 degrees, right-click on the toolbar, select Chart, and pick either of the ab icons on the new toolbar.

19…to any degree you like
If you want custom angles right-click on the cell and select Format Cells… From the pop-up menu, click on the Alignment tab, and then drag the Text pointer in the Orientation window.

20.  Zoom in to your selection
You can have Excel display just the area you’re working in by highlighting the relevant cells, clicking on the arrow on the Zoom box on the toolbar and selecting Selection from the list.