Three Simple Excel Tips – there are lots in Excel, but have you heard of these three?
simple excel tips: light bulb photo

Whilst training Excel in Worcestershire and Herefordshire recently, we had a good chat on the course with the people attending about shortcuts. There are many in Office let alone Excel, which some know about and some do not.

Shortcuts are often a great way of cutting down on the time it takes you to do something or complete a task. We often include shortcuts in our courses and it is often written down on our feedback forms by attendees as one of the best part of the course they attended!

There are many shortcuts in Excel and many ways to achieve the same ends.

It’s what suits you really but here are three not that obvious but really easy to use.

Have a try and let us know what you think.

Three simple Excel tips:

  1. A short cut for putting in the sum formula (Auto sum) – select the cell at bottom of list of numbers and click Alt key then type in = sign. It does the Auto Sum option! You can do it for multiple columns too! First select the cells then do the Alt = again and it does it!
  2. Ctrl+A short cut in Excel – select any cells in a range, ctrl+a will then select the rest of the cells in that range
  3. Insert blank rows in between a range of data. Select the rows individually through selecting and using the ctrl button on your keyboard. Then once you have done that, you click ctrl key and + sign and it adds in a blank row in between each row

For more of these and other hints and tips please visit our web site and the hints and tips page here where there are already a whole selection for you to look at and let us know if any are useful to you!

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy