Your Reading List & recommendations

How to excel at Excel: neat shortcuts

With the self-assessment tax return deadline looming (January 31st – but you already knew that, right?), we’ve been looking at some quick and easy Excel tips to help you get your books in order.

Our first tip showed you how to take easy screengrabs of certain data that you could then send on to an accountant or close mathematically minded friend. Today we’re going to look at some helpful Excel shortcuts in the software itself – you probably know how to do most of these using your mouse, but you can save time and an uninterrupted flow by using keyboard shortcuts instead.

First thing’s first: saving. Do it as you go in case of unexpected crashes:

Save your worksheet: CONTROL + S

Now a quick and easy way to add new sheets to your document:

Insert a new sheet: CONTROL + F11

Navigating can be quicker and easier if you use your keyboard instead of a mouse:

Move to the next sheet in the workbook: CONTROL + PAGE DOWN

Move to the end of a row or column: CONTROL + arrow key (in whichever direction you want to move)

And finally an easy way to add a hyperlinks in to your spreadsheet:

Add a hyperlink to a cell: CONTROL + K

 

For more tech tips and tricks, and free, impartial business tech advice, talk to an O2 Guru in store, online or over the phone.

Talk to an O2 Guru now


Tags

All articles

Growth

Public sector

Safe & secure

Start-ups

Tech advice

Work smarter