Tame your computer - top 10 tips for Excel


19-02-2018

In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she she offers her top ten Microsoft Excel shortcuts...

What I often hear from my course participants is that they came away with new tricks, tips and shortcuts that they never would have found on their own.

Here are your favourite, most commented on Excel shortcuts, with links to the relevant tips. I hope you enjoy them!

1

ALT + ENTER

Insert line breaks

2

ALT + 7

Create a bulleted list

3

CTRL + ;

Insert today's date

4

CTRL + A twice

Select the entire table, including the table headers

5

CTRL + down arrow

Move to end of a range of cells in a column

6

CTRL + G

Display the Go To dialog box

7

CTRL + T

Format as table, enabling filtering

8

F11

Create a chart in a separate sheet

9

F2

Switch to Edit mode

10

F4

Repeat your last action

 By the way, CTRL + G also works in Word and Outlook and F4 in Word and PowerPoint.

Finally, see http://www.roem.co.uk/inc/shortcut_archive.pdf for a list of all the shortcuts published since March 2013 when we launched the 'shortcut of the week' on our home page.

Keyboard shortcuts may sometimes be unintuitive or hard to remember, but I drip feed a new shortcut weekly, to help you to boost productivity without reaching for your mouse.

19 February 2018

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk

 

Highly respected computer software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.

Roem Ltd – software training and support