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:
https://chandoo.org/wp/excel-formatting-tips/
#ExcelTips #MustWatch
Видео 10 Excel formatting tricks *ONLY* experts know канала Chandoo
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
Видео 10 Excel formatting tricks *ONLY* experts know канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
☑️ Top 30 Advanced Excel Tips and TricksThe *ONLY* 10 Excel keyboard shortcuts you need to masterExcel LAMBDA Function4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Bill Jelen - MrExcel's Best Excel Tips (including a secret tip from FBI 😮)Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)GUESS what's HIDDEN in Excel? (Cool Trick)Secrets to Building Excel Dashboards in Under 15 Minutes!Excel sum values, but I can't use SUM function - 10 crazy methodsWhen Should you Use the Hash Sign (#) in Excel Formulas?10 awesome things you can do in Excel - WITHOUT any formulas or pivots10 Amazing (Less Known) Excel Tricks You Should KnowTop 10 Most Important Excel Formulas - Made Easy!Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)SUPER EASY Excel Data Entry Form (NO VBA)50 Ultimate Excel Tips and Tricks for 2020How to easily automate boring Excel tasks with Power Query!Top 20 Microsoft Excel Tips & Tricks9 Useful Excel Pivot Table Tips everyone should knowProperly Convert PDF to Excel