Excel Quick Tips - Don't Merge and Center in Excel, Do This Instead! #excel #shorts

preview_player
Показать описание
If you or someone you love is still merging and centering cells in Excel, kindly ask them to do this instead: Center Across Selection!

Merging and centering cells causes a number of problems for everything from screen readers to data manipulation, formulas, etc. There's not really a good reason to do this horizontally, so instead you should highlight your cells, go to format (Alt H F N), Alignment, Text Alignment, Horizontal, and choose Center Across Selection.

Give it a try and make a difference in the world today!

#excel #nomouseclub #shorts

Follow for Excel tips, tricks and more!

📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions:

👉 Connect with me on social!
Рекомендации по теме
Комментарии
Автор

This is great! No more meege and center on my pivot tables for presentations!

yaritzamartinez
Автор

This is hilarious! Merge & Center is pure evil, and you've been gracious enough to post this heartfelt public service announcement. Thank you! :-)

unlisted
Автор

I can actually see your Excel content on my mobile phone! 🎉 More YouTubers should make this possible. It's so hard to see their content.

FortyFourAndGore
Автор

Can you do one where that song “in the arms of an angel is playing” 😭😭

abediaz
Автор

Hey this is good one. What about Alt + H + FA Instead of Alt + H + FN.

bharathikannan
Автор

And if u can remember anymore than cut n paste then good for but I cant

Codingfortommorrow
Автор

Hey new guy who is obsessed… on this what is the benefit?

matthewhalpin