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.
3. CTRL SHIFT #
Efficiently format date values in Excel with the CTRL SHIFT # shortcut! CTRL SHIFT # automatically applies date formatting to the selected cells.
5. CTRL SHIFT %
Formatting data to percentages has never been easier than with the CTRL SHIFT % shortcut. CTRL SHIFT % automatically applies percentage formatting to the selected cells.
6. CTRL SHIFT ^
Easily apply scientific number formatting to the selected cells with the CTRL SHIFT ^ shortcut.
7. CTRL SHIFT ~
We’ve learned a lot of number formatting shortcuts, but what if we need to convert numbers back into their raw format? The CTRL SHIFT ~ has you covered. CTRL SHIFT ~ automatically applies general number formatting to the selected cells.
Never format numbers in Excel manually again now that you've learned these shortcuts!
To learn all of Excel’s shortcuts and productivity hacks like this, make sure to sign up for my new course! #excel
And if you never want to forget my excel tips at your desk, check out my shortcut merch, templates, and ebooks. shop.morningbrew.com/collections/ex…
It appears I forgot number four... so here it is:
4. CTRL SHIFT $
A majority of the time, we work with profitability data in Excel. Make sure your data is formatted correctly with CTRL SHIFT $. The CTRL SHIFT $ shortcut quickly formats numbers as currency values.
• • •
Missing some Tweet in this thread? You can try to
force a refresh
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!
Say goodbye to manually summing data in 2023 and hello to AutoSum. AutoSum automatically detects surrounding data and sums it using the SUM function. Just select the cell you want to calculate the sum in, and press ALT =.
2. Flash Fill
Thanks to Flash Fill, you can officially retire writing complex text functions to manipulate data in 2022. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear and just hit CTRL E!
You're unable to sort data if it contains merged cells. Below we have historical sales data with rows without data merged into one cell. So watch what happens when I try to sort the total sales in descending order.
Merged cells can make copying and pasting data difficult. So let’s say we received Taylor’s sales data and wanted to copy and paste it in. Again, it doesn’t work.
Being able to quickly drill down into data is critical when analyzing. Instead of applying filters manually, add slicers to the data by navigating to the Insert tab > Slicers > select what you want to filter the data by and hit OK. Now just click any button to filter!
2. Power Query
Importing data into Excel never is as easy as it seems. Luckily, Power Query is here to fix that. Power Query imports data from various sources into Excel. So instead of copying data from the web, go to Data > From Web > enter URL > select the table and hit load.