CAS cleans up data by centering text across cells without the issues that merged cells cause. Select the text followed by the cells you want to center the text across > Home tab > Alignment Settings > Center Across Selection under horizontal > OK.
2. Split Cell
Can’t decide whether to label a row or column? Try splitting the cell to label both. To split a cell, enter both labels on separate lines and move the top header to the right of the cell. Next, open the Format Cells box > Border Tab > Split Diagonal Border > OK.
3. Rotate Text
Rotating text is a great way to clean up your worksheet by removing unnecessary space in cells caused by long data headers. To rotate text, simply select the cells containing the text you want to rotate > Home tab > Orientation > Select desired orientation.
4. Justify
Having trouble fitting long text strings into a spreadsheet with formatted data? Meet justify. Select the cells where you want the text to appear > Home tab > Fill > Justify and Excel auto-adjusts the text to fill the selected cells without changing column widths.
5. Wrap Text
Fitting long text strings in a cell may seem complicated, but Wrap Text makes it simple. To wrap text, select the text you want to fit > Home Tab > Wrap Text, and Excel fits the entire text string into the cell width by ‘wrapping’ it into as many lines as needed.
6. Shrink To Fit
Unable to see data because it doesn’t fit within a cell? Luckily, Shrink to Fit can help. To shrink text to fit within a cell, go to the Home tab > Alignment Settings > Shrink To Fit > OK. Now, the size of the text auto-adjusts if the column width changes.
Who knew all 6 of these?! 🤚🏼
To learn all of Excel’s shortcuts and productivity hacks like these, make sure to sign up for my new course! #excel
Last day of the month = Budget Tracker time. 🤑Here's how you can get your financial *sheet* in two simple steps using my Budget Tracker:
Step 1. Enter your monthly money goals on the 'Monthly Goals' tab.
Step 2: Enter any transactions you make on the 'Transactions' tab. You can enter the transactions as often as you want, but I like to do it at the end of the month.
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.
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. 🤑