10 Top Tier Excel Shortcuts: π
1. ALT H O I
Idk whatβs worse: Not being able to see messy data or fixing it by manually adjusting the columns. Instead, clean up messy data in seconds by selecting it and pressing ALT H O I. ALT H O I automatically adjusts the column widths to the length of the data.
Idk whatβs worse: Not being able to see messy data or fixing it by manually adjusting the columns. Instead, clean up messy data in seconds by selecting it and pressing ALT H O I. ALT H O I automatically adjusts the column widths to the length of the data.
2. ALT =
If you donβt like math, luckily, Excelβs AutoSum tool can do the math for you. AutoSum automatically sums detected data. Just select the cell you want to calculate the sum in, and press ALT =.
If you donβt like math, luckily, Excelβs AutoSum tool can do the math for you. AutoSum automatically sums detected data. Just select the cell you want to calculate the sum in, and press ALT =.
3. CTRL ~
Donβt make auditing formulas within your worksheet more painful than it already is. Instead of viewing each cellβs formula in the formula bar, just hit CTRL ~. CTRL ~ toggles between showing a cellβs value and formula.
Donβt make auditing formulas within your worksheet more painful than it already is. Instead of viewing each cellβs formula in the formula bar, just hit CTRL ~. CTRL ~ toggles between showing a cellβs value and formula.
4. ALT W FF
Nothingβs worse than not being able to see headers when scrolling through a worksheet. To prevent this, select the first cell containing data in the table and press ALT W FF to freeze the panes. Now, the headers remain visible when scrolling throughout the worksheet.
Nothingβs worse than not being able to see headers when scrolling through a worksheet. To prevent this, select the first cell containing data in the table and press ALT W FF to freeze the panes. Now, the headers remain visible when scrolling throughout the worksheet.
5. CTRL [
Tracing down cell references can be like finding a needle in a haystack. Instead of tracing the file path, opening the file, navigating to the worksheet, and mapping the cell, just press CTRL [ to teleport to a cell reference. So much faster.
Tracing down cell references can be like finding a needle in a haystack. Instead of tracing the file path, opening the file, navigating to the worksheet, and mapping the cell, just press CTRL [ to teleport to a cell reference. So much faster.
6. CTRL K
If you need to link external data in your worksheet, CTRL K will be your new BFF. CTRL K opens the insert hyperlink dialog box. From here, just enter the address of the data you want to link and press OK!
If you need to link external data in your worksheet, CTRL K will be your new BFF. CTRL K opens the insert hyperlink dialog box. From here, just enter the address of the data you want to link and press OK!
7. F8
Donβt be that person who still selects data using their mouseβ¦ To make selecting data without the mouse easier, press F8 to activate extend selection mode, and then just select the data you want to include in the selection using the arrow keys.
Donβt be that person who still selects data using their mouseβ¦ To make selecting data without the mouse easier, press F8 to activate extend selection mode, and then just select the data you want to include in the selection using the arrow keys.
8. CTRL 9/CTRL 0
Instead of hiding rows within a worksheet using the mouse, just press CTRL 9 to automatically hide the row. CTRL 9 hides rows x15 faster than using the mouse. If you want to hide columns instead of rows, press CTRL 0.
Instead of hiding rows within a worksheet using the mouse, just press CTRL 9 to automatically hide the row. CTRL 9 hides rows x15 faster than using the mouse. If you want to hide columns instead of rows, press CTRL 0.
9. ALT F1
Visualizing your data using a chart may seem like a complicated task, but ALT F1 makes it easier than ever. Just select the data you want to visualize and press ALT F1 To automatically create a chart.
Visualizing your data using a chart may seem like a complicated task, but ALT F1 makes it easier than ever. Just select the data you want to visualize and press ALT F1 To automatically create a chart.
10. CTRL R
Instead of filling cell contents by clicking and dragging the mouse, meet CTRL R. CTRL R automatically fills the contents in the first column to the right of the selection. Similarly, you can fill contents down the selection by pressing CTRL D.
Instead of filling cell contents by clicking and dragging the mouse, meet CTRL R. CTRL R automatically fills the contents in the first column to the right of the selection. Similarly, you can fill contents down the selection by pressing CTRL D.
If you want to learn all of Excel's shortcuts, make sure to join the waitlist for my course to learn all of Excelβs shortcuts and productivity hacks.
Less than ONE WEEK left to join the waitlist now to lock in the lowest possible price ππΌeducation.morningbrew.com
Less than ONE WEEK left to join the waitlist now to lock in the lowest possible price ππΌeducation.morningbrew.com
Loading suggestions...