Neil Barrett

Do You Know The Shortcut?

Or are you still taking the long route ...

Posted on: 05/08/2013   By: Neil Barrett

Do you like to use shortcuts? I do. The wonderful thing about most computer programmes is that there are shortcuts to most functions, making things quicker and easier for the user. This month I'm going to share some useful keyboard shortcuts for Excel users ...

If you got paid the same, whether you worked for eight hours or just one, wouldn't you look for some shortcuts?

If you got paid the same, whether you worked for eight hours or just one, wouldn't you look for some shortcuts?

For those of you who don't use shortcuts, I would highly recommend that you give them a try as they can save you a lot of time.

The workers in the Parable of The Vineyard all received the same reward whether they worked for 8 hours or just the one. In the same way, whether you use the shortcuts or not you will still end up with a completed document, but you can move onto other things if you get it done quicker.

Most people know about the usual ones, although I have come across people that don't know all of these ones:

  • Ctrl N - New

  • Ctrl S - Save

  • Ctrl P - Print

  • Ctrl C - Copy

  • Ctrl X - Cut

  • Ctrl V - Paste

  • Ctrl B - Bold

  • Ctrl U - Underline

  • Ctrl I - Italics

In addition to those there are some additional nifty little shortcuts in Excel!

For instance, if you are inserting the current date or time, did you know that there is a keyboard shortcut to do that for you? To insert the current date press Ctrl and the :; key. To insert the current time press Ctrl and Shift and the :; key.

For those of you who use Format Cells - which I highly recommend so that you're not constantly having to change the format of dates, currency etc in columns - highlight the column you wish to format and then press Ctrl and 1. (Genie Jenny was excited to learn this one!!)

Another handy hint is to press F2 - or double click on a cell - to allow you to edit existing text in that cell, to save you having to mouse click in the Formula Bar to amend it. Or completely overtype it with the correct information which I know some people out there do!

And finally, if you make a mistake (which inevitably happens!) . click on Ctrl Z to Undo. If you undo accidentally or change your mind you can Ctrl Y to redo what you just undid!

It may not seem like much but you can save a significant amount of time by keeping your hands on the keyboard and manipulating the document that way. As busy business owners we know that time is money - so if we can get the same work completed in 30 mins rather than an hour then surely we should try it even it feels unnatural at first.

There were complaints from the Vineyard workers who had slogged all day because if they had known they would get the same pay for less hours then they might have started later on. Time management is not just about being focussed and not procrastinating it is also about being more efficient in tasks.

If you'd like more handy hints to improve your knowledge of Excel, give Keba Computer Services a call to arrange some 1-2-1 bespoke training. In just a couple of hours we can show you how to get the most out of Excel and save yourself time.

Until next time ...


Share the blog love ...

Share this to Google+Share this to FacebookShare this to TwitterShare this via BufferShare this to LinkedIn

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'Server.URLencode'

/V1/Func_FBCom.asp, line 87