Tame your computer - top 10 tips for Excel

19 February 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

Looking for something specific?