![](\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2020\/10\/read_icon_green_transparent.png?w=30&ssl=1\"){kind=spacer}
XLEV8 EXCEL PRODUCT MANUAL<\/span><\/h1>\n\u00a0<\/p>\n
MULTI SHEET FORMAT<\/h2>\n
[\/et_pb_text][et_pb_toggle title=\u201dDetails\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n
What it does<\/strong><\/span> When to use it<\/strong><\/span> Why to use it<\/strong><\/span> Default shortcut<\/strong><\/span> Other Details<\/strong><\/span><\/p>\n [\/et_pb_toggle][et_pb_toggle title=\u201dRelated Macros and Articles\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n Related Macros<\/strong> Other Articles<\/strong> [\/et_pb_toggle][et_pb_toggle title=\u201dExample Files\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n <\/a>Multi Sheet Format \u2013 Example File<\/a><\/p>\n [\/et_pb_toggle][et_pb_toggle title=\u201dInstructions\u201d _builder_version=\u201d4.19.4\u2033 _module_preset=\u201ddefault\u201d hover_enabled=\u201d0\u2033 global_colors_info=\u201d{}\u201d sticky_enabled=\u201d0\u2033]Prerequisites<\/strong> Instructions You can save the file you are using with the Multi_Sheet_Format<\/strong><\/span> sheet as one of up to five templates.\u00a0 When you save it as a template, you are prompted whether or not to leverage a template any time you run the Multi Sheet Format<\/strong>\u00a0macro.\u00a0 When you leverage one, the contents of the settings sheet (Multi_Sheet_Format<\/strong><\/span>) are copied to the active workbook and the contents are processed (sheet settings applied).\u00a0 Follow the instructions in cell K1 of the Multi_Sheet_Format<\/strong><\/span> sheet to save a template.[\/et_pb_toggle][et_pb_toggle title=\u201dScreenshots\u201d _builder_version=\u201d4.19.4\u2033 _module_preset=\u201ddefault\u201d hover_enabled=\u201d0\u2033 global_colors_info=\u201d{}\u201d sticky_enabled=\u201d0\u2033]<\/p>\n Screenshot of Multi Sheet Format macro \u2013 Populated settings sheet<\/p><\/div>\n<\/div>\n [\/et_pb_toggle][et_pb_toggle title=\u201dVideo\u201d _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]
Uses a settings sheet (Multi_Sheet_Format<\/span><\/strong>) to update several common formats and settings for any selected sheets, whether one sheet or hundreds of sheets are selected.<\/p>\n
When you have an existing file \u2013 generally something you download recurringly \u2013 and you want to apply several formatting or other settings to multiple sheets in one reusable bulk step.<\/p>\n
It\u2019s an efficient way to apply many common sheet formats\/settings to several sheets in one bulk step, ensuring each step is completed consistently and accurately.\u00a0 This is especially useful when you apply the same updates to the same sheets repetitively, such as in a report you download where each sheet represents a department, location, and region.<\/p>\n
None<\/span><\/strong><\/p>\n\n
Sheet Action Picker
Bulk Sheet Update
Bulk Sheet Rename
Bulk Sheet Reorder<\/p>\n
None<\/p>\n
\nIdentify the sheet(s) you want to update.<\/p>\n
\n<\/strong>After you have identified the sheet(s) you want to update, run the Multi Sheet Format<\/strong> macro.\u00a0 The first time you run it, it will create a sheet called Multi_Sheet_Format<\/strong><\/span>.\u00a0 This is where you\u2019ll configure the settings you want to apply in bulk.\u00a0 After filling in any formatting\/settings you want to apply, select any sheets you want to apply them to, and run the Muti Sheet Format<\/strong> macro again to apply them.\u00a0 These are the settings within the Multi_Sheet_Format<\/strong><\/span> sheet you can<\/strong><\/em> fill in (note that all are optional):<\/p>\n\n
![\"\"](\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2023\/01\/Multi-Sheet-Format_Screenshot_2023-01-19.png?resize=1024%2C576&ssl=1\")