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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920