Excel + ChatGPT - Center Across Selection Shortcut Macro!

🚀 Excel + ChatGPT Automation - No more annoying Merge & Center! Use this Center Across Selection shortcut macro to fix formatting with one click.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
0:00 How to write VBA Macros with ChatGPT
0:13 The Problem with Merge & Center
0:41 The ChatGPT Prompt
1:13 The ChapGPT Macro
1:55 Inserting the ChatGPT Macro
2:48 Adding the Macro to the QAT
3:18 Using the Macro

[mckiestephen]

I absolutely love your videos. You're very thorough and to the point. Thank you for not spoofing about in your videos like many do on here. I'm a professional looking for serious tutorials, not "fun 'n games"; Please keep posting 🙏

[aloobi]

I'm an advanced Excel user. Most of the time whenever I watch an Excel video, I don't learn anything new because I already know the stuff. But it's different with your videos. I always learn something new!

[krismaly]

Thanks for educating the community and appreciate your volunteering and thanks to your tram

[iankr]

Impressed that ChatGPT can do that! I use a similar macro that I've distributed to my colleagues at work. But I'd make just one small addition to that code. I check at the top of the macro that the selection is actually a range, to trap the error caused by the user inadvertently invoking the macro when (for example) a chart object is selected:
If Typename(Selection) <> "Range" Then Exit Sub

[Romanis]

Excellent, thank you - would appreciate more vids like this, where you outline either a) super useful/complex macros in detail (generated by chatbot, or not) and/or b) more of a compilation vid of several macros and what they do/their effect accompanied by the code in description for easy use by us 🤔😊

[chrism]

Very cool Mynda. We're just scratching the surface of what the AI will be able to do in Excel!

[steven.h]

Dang.. I've been the Macro King for decades, it used to be the only way to get things done in my environment.

[jerrydellasala]

Awesome. I don't know when Center Across Selection became available, but I only found it a couple of years ago after using Excel for decades and hating Merge & Center. I had a simple one line Macro that I had assigned to the QAT, but this macro is much better! Thanks!

[volkerschuster]

Incredible video as always....thank you Mynda

[abmmozahid]

Your content is so helpful for me.Thank you so much ❤

[IvanCortinas_ES]

Excellent practical application of AI. Thank you Mynda!

[tmb]

Oh wow, had no idea about this. The possibilities are intriguing. Thanks!

[missamo]

Brilliant! What a clever little trick to make it easier to center the Mynda-approved way :)

[MegaTrickykid]

great as always! thank you very much indeed. I now also use "CHATTY" almost daily to create VBA or python script and I am very content with the results. CHATTY is a fine chap 😄

[Pfupfi]

Great work by Chat GPT and you bringing it about in a understandable way

[LuisCarlosChavez]

You're awesome, thank you! Excel and you make my job so much easier.

[erikguzik]

Really like this macro, I should have done this a long time ago Side note: as i step through VBA Code many times, i have set a button on my mouse to do the key stroke F8. now I just need to make this macro the 8th item on my QAT. so i can select the cells, hold ALT and click the mouse button (so its like ALT F8 - to use the 8th item in QAT)

[AndresHortillosa]

Always informative and so useful. I will download it myself.

[josecarlosconejo]

Very nice video. I will give good use to the learnings 😊. I would suggest videos on how to link Excel with Power Point using VBA or one to name VBA functions without the PERSONAL!… prefix

[MagicJim]

Hi Mynda, I'm going to give ChatGPT a try to create the same macro but using Excel Automate Scripting instead of VBA.