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:
https://chandoo.org/wp/excel-formatting-tips/
#ExcelTips #MustWatch
