Tips & Tricks: Top Five Excel Shortcuts
Use our Tips & Tricks to improve your efficiency! Our aim is to keep them relevant, concise & accurate.
We’re incredibly pleased to introduce you to the very first installment of our ‘Tips & Tricks’ series!
So many office jobs revolve around working on Microsoft Office. It’s by no means unfair to say that the most powerful yet underutilised Office programme is Microsoft Excel. So the question every business will ask itself at some point is ‘How can I be more efficient on Excel?’ – Well, we can help. We work on and with computers on a day-to-day basis so we know what ticks. So we’ve decided to be extra helpful and list the top five Excel shortcuts. There’s plenty others too, but really, no one want’s to try and remember 25 keyboard shortcuts that may or may not save time.
And to make things even easier for you we’ve created a short video to show you exactly how to use these shortcuts:
1. Ctrl+; – Enter Current Date
This little trick enters the current date instantly. If you don’t know how to use this, and you enter dates a lot, this will save you valuable time. When we process orders for our Telecoms customers, we enter plenty of connection dates and always date our notes to ensure we know what’s happening and when. If we’re connecting 40 lines, entering the order date and connection date can be made so much easier with this shortcut.
2. Ctrl+Space and Shift+Space – Select Row/Column
Selects the entire column/row of the current cell. Dragging your selection across can be tedious if you have large amounts of data and this way you can copy data back and forth without even needing to use your mouse.
3. Ctrl+C/V/X – Copy, Cut, Paste
Copying, cutting and pasting. Everyone knows how to use this for word processing but not everyone knows how clever excel can be with it. It will automatically adapt formulae in your data and this can make life so much easier.
4. Ctrl+Y – Repeat Last Actions
This repeats your last action. Whether it’s formatting a single cell or inserting entire rows, this can save you lots of time. F4 will do the same job. This is particularly useful when you are inserting blank rows into a table.
5. Ctrl+Shift+L – Add/Remove filters
You’ve got data, and you want to analyse certain parts of it. You set filters, but clearing each filter is a pain. Using Ctrl+Shift+L twice, you can clear them all by turning the off and then on.
Top Five Excel Shortcuts? Is that it?
So, you’ve heard the top five Excel shortcuts. But how else can you improve efficiency? Of course, the best way to use Excel is to use the most efficient version. Office 365 incorporates the latest version, Office 2013, with an inherent usability, with all office programmes installable on up to 5 PCs, and accessible via tablet and online, it can be incredibly useful for businesses. This can be provided through your Business Mobile contract or on it’s own. For more information, visit the Office 365 for business comparison.
And so the first of a series of blogs comes to and end. It won’t be too long before our next top five shourtcuts list comes out though, so watch this space.
Please be aware that if you have an older version of Excel then it’s possible that some of these shortcuts may not work.
Was this helpful? If you love being efficient when using IT, then you should take a look at our IT services. If you like efficiency, you’ll love what we do.