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 ...

NEIL BARRETT




   Buffer
Click here to Share, Email or Bookmark this website




More about Neil Barrett ...

KEBA COMPUTER SERVICES

I have always worked in the IT industry both for in-house IT departments and outsourcing companies. My first position was for a large managed services provider in Coventry, based full-time on a customer site in Northamptonshire. It was during this assignment I was exposed for the first time to the UNIX & Linux operating systems which I still enjoy looking after today. By the time I left there I was running the Department and went on to head up the IT department of the distribution arm of a manufacturing company on the Warwickshire / Northamptonshire border.

Although the position was well paid and had great benefits, it wasnt particularly challenging and that's when I set up my own business. Keba was born. It was about nine months later in the summer of 2002 that that I decided to do it full-time and never looked back.

Telephone:

+44 (0) 1327 300311

Website:

http://www.kebacomputers.co.uk


More of my blog posts for you to enjoy ...

For Service Above And Beyond
As standard not premium ...

Is your answerphone holding you back?
10 reasons why a call handling service is better ...

Have you had a holiday this year?
Are you one of the 69%?

When you're really busy
You may not want to answer the phone ...

You Know You Work For A
Telephone Call Handling Service when ...

I Heard It On The Grapevine
Well, the radio actually ...

Life is like a box of chocolates
You never know what you're going to get ...

Through Thick And Thin
Is Shorthand A Dying Art?



Posts from my blogging community ...

7 Top Tips That Lead To Interview Success
Posted on: blog.theafa.org.uk

People Are The Driving Force Of Your Business
Posted on: blog.andromedaconsulting.co.uk

Tax-Efficient Options For Your Retirement
Posted on: blog.ruggedtough.com

Fire Safety: Have You Checked Your Fire Doors Recently?
Posted on: blog.picaw.com


GET OUR FREE EBOOK:

* indicates required

Keep in touch ...

Send us an email
View our RSS newsfeed
Find us on Facebook
Follow us on Twitter
Connect with LinkedIn
Follow us on Pinterest

 

By Category ...

Business Tips (40)

Call Anwering (11)

Call Handling (88)

Customer Experience (2)

Event Management (3)

General (29)

Guest Posts (8)

Networking Tips (3)

Virtual Assistant (17)

By Popularity ...

Call Handling For Profe ...

Daddy Daycare

Is your answerphone hol ...

Through Thick And Thin

Giving your event the x ...

The Pros and Cons of a ...

Dropping Like Flies

Why you need a Virtual ...

Call Answering: Love Is ...

When you're really busy

Quote of the day ...

"Sometimes the littlest things in life are the hardest to take. You can sit on a mountain more comfortably than on a tack"

Login ...



Remember me