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.
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.