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.
Frequently Asked Questions
What does the F4 key do in Excel?
F4 repeats your last action, so if you fill a cell with colour, for example, pressing F4 will apply the same formatting to the next cell you select.
Is there a quick way to spell check a cell in Excel?
Yes - pressing F7 will spell check a single cell or the entire document with the click of one button.
How do I select a whole column or row quickly in Excel?
Ctrl + Space highlights a whole column, and Shift + Space highlights a whole row.
Can I add more than one line of text inside a single Excel cell?
Yes - press Alt + Enter to move down a line within the same cell as you type, letting you fit multiple lines of text into one cell.
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.