Better Than Merge and Center: Excel's Center Across Selection

[@teacheme]

After all my years of using spreadsheets (going back to Lotus 123 in the early 80''s) I thought there was nothing new to learn. Wrong. Today I learned something new. Thank you for that.

[@kakylong2]

Wow! This was awesome. I use merge & center all the time. I will definitely be using the new method. Great video!

[@lynnepouliot4268]

Brilliant! I've frequently run across the problem caused by merge and center without knowing this alternative. Thank you so much!

[@lynnepouliot4268]

I just wanted to come back to say I use this all the time now!!

[@readyplayer2880]

These are the best shortcuts I've found so far to "center across selection". Thanks!

[@orlahastings4563]

Great tip. I have often found it frustrating using merge and centre, this is exactly what I need. Thank you very much for sharing. 👍👏

[@KRAFAEL03]

Thank you very much. This will helps me a lot in my duties.

[@ian10432]

Thanks! I was trying to figure this out for a few weeks now! Very helpful

[@paulgoodman8950]

Excellent explanation. Very useful.

[@kathleenbabb7023]

Thank you, the tricks and tips you share is very useful.😊

[@immanueldeutsch8018]

Excel...lent!!
I'll use this all time! 👏🏻🤓

[@gopalakrishnan5895]

This chapter is 👌 🌲 You are a Knowledgeable Person

[@lamaterfamilias]

ok, that is exactly what I needed just now, thank you! I don't have those extra selection options on my ribbon, I had to go to Format up at the top menu bar. How do I add those options you used to get to Format options?

[@mouhanadalazem8339]

That is great our teacher
Many thanks

[@MaryamLotfjou]

Thank you so much, it was really helpful❤

[@abhinavkarkare]

Thank you! Very helpful.

[@missthunderstormable]

Lovely! Didnt know that better option!!

[@medbh9493]

Very informative, Thanks

[@AbdulSalam-db3pg]

this is a very useful tip. i really wonder why so few likes !

[@edmunlum]

Thanks for this guide.

[@musictime3541]

Wow! This method isn't better it's best i really like it

[@muhammadazam339]

Excellent! Very useful😀😀😀😃

[@Senseless_Sensei]

Very helpful ❤

[@priotapriota6244]

Hi can you make video for Group policy and file sharing?

[@lydethful]

Is there a faster way to do that centre across selection? Seems like there're many steps to get it done.

[@cherylzaccone9685]

Brilliant!

[@acacia_w]

Thank you!!!!!

[@2klatte]

Can you just use the format painter for centre across selection for all the tables here?

[@mekuaninteyayu6267]

Thank you

[@MomCareMoments]

Excellent

[@enochjnr6341]

Helpful.

[@oneton7292]

I`m wondering if I can put this on the Ribbon as a shortcut?🤔

[@lynnepouliot4268]

Please let us know if you discover a way. Wouldn't that be a sweet shortcut!

[@immanueldeutsch8018]

Perhaps, writting a macro, and adding a button that calls it.

[@karyotesnyan7265]

So with this new information, what function does Merge & Center have now? Is it completely redundant now?

[@ShanmukhaRaoBoeerishetti]

Thanks

[@techteachersandstudents]

Thank you so much for your kind gift. I'm glad you found the Excel Center Across Selection video to be helpful. Thank you!

[@AllenBennett-vp6gd]

Is there a way to have the text "Only enter data in bright yellow cells", but have the text "bright yellow" (only) highlighted in (you guessed it!!!) bright yellow?

[@MomCareMoments]

Please explain how to do Center Across in Google Sheets

[@emmanuelhenrick7191]

How can this be done horizontally?

[@tedhead3162]

I like it💥✔☘

[@sefu324]

but how do i make if the text is bigger, on two rows? how do i make start from left the second row?

[@rolfmeier8469]

Danke!

[@techteachersandstudents]

Thank you so much for your kind gift! I'm glad you found the video to be helpful.

[@sheharyarahmed8202]

Excuse me brother can you tell me how to upgrade hp pc. Model type dc5750. It's core 2 duo laptop. Please

[@lthegr81]

1st

[@aravindans3171]

Thank you