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:

Watch next 😀:
=============

#ExcelTips #MustWatch

[MRaedAlLulu]

Yes, this is how experts do..
Thank you, Chandoo!

[TheROMaNProject]

I have considered myself to be a “power user” of Excel, having used it since first introduced to the market. Yet I wasn’t aware of any of these very useful “hacks”. Thank you for teaching these to us, and for showing so many real life examples! Kudos...

[jimmylui]

1. Merging without merging - centre across selection 0:28
2. Merge multiple cells with "Merge across" 2:14
3. No decimal points for large numbers with Custom cell formatting 3:11
4. Showing numbers in Thousands or millions with Custom cell formatting 5:10
5. New line in a cell with ALT+Enter 7:08
6. Copy widths alone with paste special 8:03
7. Skip zero in chart labels with custom cell formatting 9:08
8. Align & distribute charts with alignment tools 11:47
9. Show total hours with [h]:mm custom code 13:48
10. Text format for very long numbers 15:05

[wilsonthundil]

From last 7 years I am your big follower, Really amazing your talent

[surajbhardwaj]

Wonderfully explained.... Calculating hours is best...👌👌

[gwen-mr]

I am a former "expert" now retired. It's fun to see functionality presented this way. Good work. And thanks. This does leave me wondering if there is a way to display multiple cell formats, similar to the way that cell formulas can be displayed.

[Everyonelovesyou]

I came across all these problems..there is so simple way to fix ...Thanks Chandoo...I hv been your viewer since 1decade now

[CrispusAttucks]

Man thank you!!! That merge and center option helped immensely!!!

[Acheiropoietos]

I have been using Excel for 20 years. These tips will help me for another 20. ❤️
btw, I knew alt+enter 😎

[oliviasimon]

Great tricks. Just adding on, Trick1: "Center across Selection" is same as mergecell. Even after "Center across selection" You will not find values in the corresponding cells, but one

[ri_ma_ri]

For No. 7, I just changed the font color to white and it does the same trick. Great vid thought, I learned something new :D

[ashleyspencer]

One I like that not many people know is when you have built your perfect chart you can then paste special formats to your other charts for a consistent look.

[PaulasPicks]

This was awesome! I knew a couple already, but the rest were a-ha moments! Thank you!

[dhunpagla]

Merge across is new added in my knowledge book ...Thanks Mr. C 😎🙏

[BalaBharathkv]

I am glad that i know 6 of them already

[stephenbarrett]

With the last tip, if you want to use the value of the number entered as text, you can use eg =VALUE(A1)+10
This retruns the value of the text entry, as best as Excel can determine.

[NabilDerouiche]

Very good, thanks. For 10th point to format a very long numbers you can put ' before the number and all will be OK.

[davidjordan]

I actually learned a trick or two - much to my amazement . Thank you

[jeanjeannie]

Thank you! Your instructions are so clear and very useful - a big help : D

[uyube]

These tricks are easy but explained nicely by Chandoo. The problem is knowing when to use them.