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.
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!
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!
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.
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.
“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
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…
Share this Scrolly Tale with your friends.
A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.