If you click the Show button, the custom view will appear in the worksheet. You will then see the Custom Views dialogue box. Go to the View tab and select Custom Views. In addition to creating macros to view scenarios, you can also create macros to access custom views. Switching Between Custom Views with Macros You can now view that scenario by running the macro. You will want to store the macro in the workbook.Ĭlick OK, then record yourself opening up the Scenario Manager, selecting a scenario, then clicking the Show button. Name the macro so that you know which scenario it is, then specify a keyboard shortcut. To create a macro for a scenario, go to the Developer tab and select Record Macro. That way, we can view a scenario simply by using a keyboard shortcut. Instead, we can create a macro for each scenario and add a keyboard shortcut for each macro that we create. If we want to see another scenario, we go back to the Scenario Manager, select the scenario we want to view, then click the Show button again. We can select any of these scenarios, then click Show to see the scenario in our worksheet. If we go to the Data tab, click the What-If Analysis button, then click on the Scenario Manager, we can see all the scenarios we have created.

Remember to stop recording when you finish all the steps involved in your macro. Notice that we are storing this macro in our personal macro workbook. This way, it is available in all workbooks, and we can use it no matter what workbook we have open. 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.

How to enable macro in excel 2016