10 Excel formatting tricks *ONLY* experts know

Here is my top 10 list of formatting tricks in Excel that only pro users would know.
1. Merging without merging - centre across selection
2. Merge multiple cells with "Merge across"
3. No decimal points for large numbers with Custom cell formatting
4. Showing numbers in Thousands or millions with Custom cell formatting
5. New line in a cell with ALT+Enter
6. Copy widths alone with paste special
7. Skip zero in chart labels with custom cell formatting
8. Align & distribute charts with alignment tools
9. Show total hours with [h]:mm custom code
10. Text format for very long numbers
For more tips on Excel formatting, check out these pages:
chandoo.org/wp/excel-formatti...
Watch next 😀:
=============
10 Data Clean-up tricks with Excel (250k+ views) - • Data cleaning in Excel...
10 Awesome things you can do with Excel (220k+ views) - • 10 awesome things you ...
5 Skills you need to have to be a GREAT data analyst (150k+ views) - • 5 key skills you need ...
My most popular videos (playlist) - • Most Popular Excel & P...
Data Analysis Skills (playlist) - • Beginner to Pro FREE E...
#ExcelTips #MustWatch