10 Tricks That Can Make Anyone An Excel Expert

One of our support team was on a call this week with a business owner that was having a bit of a nightmare with Excel.

Turns out we found a solution using a few tricks that sorted things out in a jiffy, and it made us think… why not share some of these ‘tricks’ with you!

So here’s a handy list of Excel shortcuts to help you out:

F2 is a quick way to edit a selected cell or its contents.

F4 repeats an action. So, if you fill a cell with colour for example, pressing F4 will do the same in the next cell you select when pressing F4.

F7 will spell check a cell or the entire document with the click of one button.

F11 will create a chart from information from cells or highlighted data.

Alt + Enter will allow you to have multiple lines of text within one cell by moving down a line when typing and pressing Alt + Enter.

Alt + = will calculate the sum of all the cells above.

Ctrl + Space highlights a whole column.

Shift + Space highlights a whole row.

Ctrl + F6 will switch between other open windows and worksheets.

Shift + F3 will open up the Formula window to make calculations.

Making an Excel spreadsheet doesn’t have to be complicated or time-consuming. Learning a few (or all) of these shortcuts could have you working a lot faster and far more productively.

I hope you found this info useful. If there’s anything we can help you with then please don’t hesitate to get in touch.

To find out how we can best support you, be sure to request a free quote and brochure by clicking on the orange button below. We’d be delighted to work with you!

Until next time.