Three Simple Excel Tips – there are lots in Excel, but have you heard of these three?
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:
- 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!
- 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
- 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!