Hi Jason. Great list of tips and tricks! And thanks for showing people how to use Center Across Selection vs. Merge & Center which almost always leads to problems on the worksheet. Thanks for sharing :)) Thumbs up!!
Very useful, thanks for sharing, could you please make another video to explain other useful characters like “@“ for making selections in custom formats, thanks.
You can set the format on cells to include the comma separator. Just go to Format Cells-Number and check the box for thousand separator. Unfortunately, there is no option to set that for the entire spreadsheet as default.
The centre across selection is a gem
Hi Jason. Great list of tips and tricks! And thanks for showing people how to use Center Across Selection vs. Merge & Center which almost always leads to problems on the worksheet. Thanks for sharing :)) Thumbs up!!
My pleasure!
I really do appreciate you sharing your excel knowledge👍
My pleasure!
OK, #3 and especially #10 alone was worth the price of admission for me! I've wanted bullet points for ever! Thanks a lot!
Excellent!
I like how you can display text when a cell has a zero value, very cool!
I really need this video for Excel reference. I keep forgetting them when I don't use Excel for a while 😅
Thanks for the video.
Glad it was helpful!
The last point is a lifesaver. thanks for the video
Glad it helped!
New subscriber. Awesome tips. Thank you!!!
These are really helpful! Thanks Sele :)
Easy effort...... more gainful ...👍
A very useful video, thank you for sharing the tips and tricks!
Hi Jason, really useful and well presented! Thanks Andrea
Glad it was helpful!
Tips are always Amazing!
Glad you think so!
Amazing!
Very informative vlog and by the way gr8 voice 👏🏼👍🏼
Thank you so much 🙂
Thank u.
good job
Thank you for this great tutorial. I wanna add some good tricks as blow;
Hide Zero (#;)
Black bullet shortcut Alt+6+7+8 ...👍
Good tips
Very useful, thanks for sharing, could you please make another video to explain other useful characters like “@“ for making selections in custom formats, thanks.
Is there a way to keep the numbers like this 1,000 ... i hate when excel make it 1000 ... especially with large numbers
You can set the format on cells to include the comma separator. Just go to Format Cells-Number and check the box for thousand separator. Unfortunately, there is no option to set that for the entire spreadsheet as default.
@@SeleTraining Thank you, you are awesome
In last tip it is not possible to paste symbol in custom segment (ctrl+v)
You have to make sure you are using a font that has symbols included. As mentioned, you can't mix different fonts.
Yes, font is the same.. I have tried everything and checked, but it is not possible in my case.. I don't know what can be a problem..
the 2 people who disliked this video have anger issues lol
LOL. I get about 2% on every video. It doesn't matter what it's about or how good the video is.