Save hours and your sanity using these 10 Excel shortcuts:
1. ALT H O I
Nothing is worse than passed along messy data. Instead of manually adjusting the column widths in the header to clean it up, try ALT H O I. ALT H O I automatically adjusts the selected cells’ column widths to equal the size of their contents.
2. ALT H O A
Now that we know how to adjust our cells' column widths automatically let's learn how to adjust their row heights! ALT H O A automatically adjusts the selected cells’ row heights to equal the size of their contents.
3. CTRL SHIFT +
It's time to retire the context menu for inserting cells. CTRL SHIFT + opens the insert dialog box, which is used to insert new cells and choose how to shift existing cells. If an entire row/column is selected, CTRL SHIFT + automatically inserts a new row/column.
4. CTRL -
Now that we know how to quickly insert new cells let's learn how to delete them. CTRL - opens the delete dialog, which is used to delete cells and choose how to shift existing cells. If an entire row/column is selected, CTRL - automatically deletes the new row/column.
5. CTRL 9
Say goodbye to using the mouse to hide rows in your worksheet, and hello to CTRL 9. CTRL 9 automatically hides the active row. If multiple rows are selected, CTRL 9 will automatically hide them all.
6. CTRL 0
Now that we’ve learned how to hide our rows without using our mouse, it’s time to learn how to hide columns. CTRL 0 automatically hides the active column. If multiple columns are selected, CTRL 0 will automatically hide them all.
7. CTRL SHIFT &
Instead of clicking through the ribbon whenever you want to add borders to a selected cell or table, try the CTRL SHIFT & shortcut instead! The CTRL SHIFT & shortcut automatically adds outside borders to the selection.
8. CTRL SHIFT _
Now that we know how to add borders without using our mouse let's learn how to quickly remove them. CTRL SHIFT _ automatically removes all borders from the selected cells.
9. ALT W VG
Team gridlines or no gridlines? If your team no gridlines, this one is for you. ALT W VG removes all gridlines from the active worksheet. If you are team gridlines… don't worry; you can hit ALT W VG again to add them back.
10. SHIFT F11
Let's say we need to insert a new worksheet into our workbook, but we lost our mouse. Not a problem! Just hit SHIFT F11. SHIFT F11 quickly inserts a new worksheet into the active workbook.
Formatting your worksheets with these shortcuts is x10 times faster than using the mouse.
To learn all of Excel’s shortcuts and productivity hacks like these, make sure to sign up for my new course! #excel
Need to flip the rows and columns in your data table? Instead of manually interchanging each row and column, try the TRANSPOSE function. Just select the data you want to transpose as the array argument, and Excel will automatically flip your data.
2. SEQUENCE
Never waste time typing out numbered lists again using Excel’s SEQUENCE function. SEQUENCE quickly and easily creates a list of sequential numbers for you. Just enter the number of rows you want in the sequential list as the rows argument.
Creating scannable barcodes may seem like a difficult task, but Excel actually makes it easy. First, add an “*” before and after each product code using the ampersand symbol. Then just update the font to “libre barcode 128” to create the barcodes! Easy.
2. AutoCorrect Symbols
Instead of manually searching for and inserting symbols, you can code them into Excel using AutoCorrect. Hit ALT F T > Proofing > AutoCorrect Options. Enter the phrase that'll represent the symbol next to ‘Replace:’ and the symbol next to ‘With:.’
The CTRL SHIFT ! automatically applies number formatting to the selected cells. Number format rounds numbers to two decimal places and adds commas.
2. CTRL SHIFT @
Never waste your time formatting time values manually again with the CTRL SHIFT @ shortcut. CTRL SHIFT @ automatically applies time formatting to the selected cells for you.
My Habit Tracker is OFFICIALLY LIVE! This tracker is a fully customizable template that will help you get organized this year and stay on top of your goals by tracking daily, weekly, monthly, and annual progress. 🤤 But wait, that’s not all...
My Wellness Tracker is also here! This tracker will help you achieve your wellness goals this year by tracking steps, water intake, mood, sleep, and more. The annual and monthly visuals to show progress are top-tier. 💪🏼 But there's even more…
Last but not least, introducing: my Budget tracker! This tracker will help you better budget your money to achieve your money goals this year. All you have to do is set monthly goals, enter your transactions, and the tracker will do the rest. 🤑
5 shortcuts that will make analyzing data a little bit easier:
1. ALT =
Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.
2. CTRL H
Finding values in your workbook and replacing them one by one could take hours, but not with CTRL H. The CTRL H shortcut opens the find and replace dialog box, which finds a value and replaces all instances with a new specified value.
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!