5 formula shortcuts all Excel users must know:
1. F4
One of the best ways to avoid errors when writing formulas is by locking reference cells. Instead of typing out the dollar sign in the cell reference, try the F4 shortcut. F4 quickly toggles through absolute/relative referencing.
One of the best ways to avoid errors when writing formulas is by locking reference cells. Instead of typing out the dollar sign in the cell reference, try the F4 shortcut. F4 quickly toggles through absolute/relative referencing.
2. Alt =
Do you feel like you spend too much time summing data in Excel? Try the Alt = shortcut instead. Alt = automatically sums data detected around the cell. Just select the cells that you want to add totals to, hit Alt =, and let Excel do the work for you!
Do you feel like you spend too much time summing data in Excel? Try the Alt = shortcut instead. Alt = automatically sums data detected around the cell. Just select the cells that you want to add totals to, hit Alt =, and let Excel do the work for you!
3. CTRL SHIFT F3
Stop manually selecting cell ranges within your formulas. CTRL SHIFT F3 creates a named range named using the headers that can be referenced directly in formulas. Now, you can simply type the name of the column you want to reference in your formula!
Stop manually selecting cell ranges within your formulas. CTRL SHIFT F3 creates a named range named using the headers that can be referenced directly in formulas. Now, you can simply type the name of the column you want to reference in your formula!
4. CTRL [
Tracing a cell reference in Excel can seem never-ending, especially when the cell is linked to multiple external workbooks. Luckily, CTRL [ can help! CTRL [ jumps to direct cell references, even if it’s in an external workbook.
Tracing a cell reference in Excel can seem never-ending, especially when the cell is linked to multiple external workbooks. Luckily, CTRL [ can help! CTRL [ jumps to direct cell references, even if it’s in an external workbook.
5. CTRL ~
When cranking out formulas in Excel, it can be hard to keep track of all the formulas within your spreadsheet. Instead of clicking on each cell to view the formula individually, try hitting CTRL ~. CTRL ~ toggles between showing cell formulas and values.
When cranking out formulas in Excel, it can be hard to keep track of all the formulas within your spreadsheet. Instead of clicking on each cell to view the formula individually, try hitting CTRL ~. CTRL ~ toggles between showing cell formulas and values.
“Formulate” a better Excel process with these shortcuts!
To learn all of Excel’s shortcuts and productivity hacks like this, make sure to sign up for my new course! #excel
Sign up 👇🏼 education.morningbrew.com/excel
To learn all of Excel’s shortcuts and productivity hacks like this, make sure to sign up for my new course! #excel
Sign up 👇🏼 education.morningbrew.com/excel
Follow me @exceldictionary for even more Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks.
shop.morningbrew.com/collections/ex…
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks.
shop.morningbrew.com/collections/ex…
• • •
Missing some Tweet in this thread? You can try to
force a refresh
