We are going to call this macro salesWorksheetFormatting. Formats the cells to Number with three decimal places. Sets a theme (under the Page Layout tab).ģ. We are going to create a macro that does the following things:Ģ.
In essence, you can create macros to do all the formatting for you. This way, you only apply the formatting once. After that, all you have to do is run the macro.Ī macro can contain as many steps as you want it to contain. You can create a macro that changes the font type, color, and size, then also applies cell formatting and row and column sizes. To save time and make things easier, you can use macros to format cells and worksheets simply by creating macros that do all the formatting for you. Formatting with Macrosįormatting cells in workbooks can be a tedious process, especially if you have to format each worksheet in workbooks that you create. We are going to continue to explore macros in this article and learn more about creating and working with them.
