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
CTRL E makes complicated tasks easier than ever, thanks to Flash Fill. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will fill the pattern down the column in a flash.
2. 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 =.
Formatting is key to creating professional-looking spreadsheets. Here are the top 10 Excel formatting shortcuts:
1. ALT H O I
Have you ever opened a workbook and not been able to see the data? Instead of manually adjusting the column widths in the header, 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 automatically adjust our cells' column widths, 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.
5 Excel mouse shortcuts you don't know but should:
1. Copying Data
99% of Excel users copy and paste data daily, so why not do it as efficiently as possible? Just select the data you want to copy, hold CTRL, and drag the data to where you want it to be pasted.
2. Moving Data
Now that we know how to quickly copy data, let’s learn how to quickly move it. Instead of cutting and pasting, select the data you want to move, hold SHIFT, and drag the data to its new location.
If you use Microsoft Excel, you need to know these 6 text formatting hacks:
1. 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.
2. 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.
Utilizing keyboard shortcuts will save you hours when working in Excel. Here are the top 50 Excel shortcuts to maximize productivity:
CTRL N ➡️ Open New Workbook
CTRL S ➡️ Save Workbook
F12 ➡️ Save As
CTRL W ➡️ Close Workbook
CTRL Z ➡️ Undo
CTRL Y ➡️ Redo
CTRL F ➡️ Find
CTRL H ➡️ Find & Replace
CTRL ; ➡️ Insert Current Date
CTRL SHIFT ; ➡️ Insert Current Time
CTRL C ➡️ Copy
CTRL X ➡️ Cut
CTRL V ➡️ Paste
CTRL ALT V ➡️ Open Paste Special
CTRL ENTER ➡️ Fill Selection
CTRL D ➡️ Fill Down Selection
CTRL R ➡️ Fill Across Selection
CTRL ARROW ➡️ Move To Furthest Cell
SHIFT ARROW ➡️ Select Next Cell
CTRL SHIFT ARROW ➡️ Select To Furthest Cell
Have you ever opened a workbook and not been able to see the data? Instead of manually adjusting the column widths in the header, use ALT H O I. ALT H O I automatically adjusts the selected cells’ column widths to equal the size of their contents.
2. CTRL E
CTRL E makes complicated tasks easier than ever, thanks to Flash Fill. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will fill the pattern down the column in a flash.