Excel - Automate Cell Formatting in Excel with Macros - Save Time and Effort! - Episode 384

1,366 views · Published 20 October 2009 · 2:21 · Indexed 6 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Automate Cell Formatting in Excel with Macros - Save Time and Effort!

Welcome to the MrExcel netcast, where we explore all things Excel. In this video, we will be discussing how to create a formatting macro in Excel 384. Have you ever found yourself constantly formatting cells with the same style over and over again? It can be a tedious and time-consuming task. But fear not, because with the help of a simple macro, you can automate this process and save yourself a lot of time and frustration.

During a recent power Excel seminar, a participant shared a unique problem they were facing. They had to repeatedly select a cell and apply a specific formatting style, which involved a light blue background, dark blue bold font, and a blue box around the cell. This was driving them crazy, as it required multiple steps each time. This is a perfect example of when a macro can come in handy and make your life easier.

To create a macro, simply go to Tools, Macro, and select Record New Macro. Give your macro a name, such as FormatBlue, and assign it a shortcut key, such as Ctrl+J. Next, choose to store the macro in the Personal Macro Workbook so that it is available in all of your workbooks. Now, without selecting any cells, format the current selection with the desired style. In this case, we would choose a light blue background, blue font, and bold, and then click OK.

Once you have completed the formatting, click on the Stop Recording button. Now, whenever you need to apply this formatting style, simply select the cell and hit the assigned shortcut key, and Excel will automatically format the cell for you. This is a great way to automate repetitive tasks and save yourself time and effort. Thank you for watching this netcast from MrExcel, and be sure to check out our other videos for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Formatting Same Style Repeatedly
(00:21) Description of the problem
(00:32) Solution: creating a macro
(00:42) Steps to create a macro
(00:55) Assigning a shortcut key
(01:05) Storing the macro in Personal Macro Workbook
(01:15) Formatting the current selection
(01:35) Stopping the recording
(01:45) Using the shortcut key to format cells
(01:55) Benefits of using macro recording
(02:05) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Automating tasks in Excel
Blue formatting in Excel
Creating a macro in Excel
Formatting cells in Excel
Formatting cells with a macro in Excel
Formatting options in Excel
Keyboard shortcuts in Excel
Personal Macro Workbook in Excel
Power Excel seminar
Recording macros in Excel
Shortcut keys in Excel
Using macros to save time in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152697/


Someone posed this question in a recent Power Excel seminar - he had to format cells with a strange format, and had to do this repeatedly. Learn how to record a simple macro to automate this task. Episode 384 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

More from this channel