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

Until next time, happy computing!

Dom