Discover new tools to get things done.
This tool lets you import all sheets from another Excel file into your current workbook.
The sheets from the selected file are added to the end of your workbook.
If a sheet with the same name already exists, a number in parentheses is added to the new sheet name to avoid duplication. For example, if your workbook already has a sheet named "Sales", the imported one will be named "Sales (2)".
This tool is useful when you want to:
Note:
Any macros that may exist in the Excel file are ignored and not imported.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Tip:Alt+P for the previous tool.