Workbook Manager for Microsoft Excel

This help page illustrates different ways of managing your Excel files with the help of Workbook Manager. Create, open, sort, rename, hide/unhide, print, close and delete your workbooks and worksheets easily. Just pick the option you need and see how to achieve the result.

How to use the Workbook Manager tool

Start Workbook Manager

To run the tool, click on the Workbook Manager icon in the Manage group on the Ablebits Data tab:
Run the tool by clicking on its icon on Excel ribbon.
You will see the add-in pane with all currently opened workbooks and sheets in the worksheet tree. There's also a toolbar with the options that help you manage these Excel files.

How to create a new workbook

There are three ways to create a new workbook:

  • Click on the New Workbook button on the add-in's main toolbar:
    Use the toolbar to create a new workbook.
  • Click on the down arrow next to the New Workbook icon and choose the corresponding option from the drop-down list:
    Use the drop-down list to create a new workbook.
  • Use the Ctrl+N keyboard shortcut to get a new workbook.

How to create a new worksheet

You can create a new worksheet in three different ways:

  • Click on the down arrow next to the New Workbook icon on the toolbar and select Worksheet:
    Create a new worksheet using the option from the menu.
  • Use the Ctrl+Alt+W key combination to get the same result.
  • To create a new worksheet from the worksheet template, click on the arrow next to the New Workbook icon and select the necessary worksheet template from the drop-down list:
    Choose the necessary worksheet template from the drop-down list.

How to open a workbook

Click on the Open icon on the add-in's toolbar and you will see a standard Explorer window where you can browse for a workbook:
Click this button to open Excel workbook.
The keyboard shortcut you can use for the same result here is Ctrl+O.

Tip. To open recently used workbooks, click on the down arrow to the right of the Open icon:
See recently used workbooks in this list.

How to rename worksheets and workbooks

  1. Select the worksheet or workbook of interest in the list and click the Rename button on the toolbar:
    The Rename button.

    Or, right-click on the worksheet (workbook) and select the Rename option from the context menu.

    Tip. You can also use the F2 hotkey.

    Select this option to rename your worksheet or workbook.

  2. After you type a new name, press Enter to save it:
    Press Enter on your keyboard to save a new name.
Tip. You can also take advantage of the Save as option to save your workbook under a new name. Please see How to save a file under a new name.

How to save changes to the file

You can save the changes you made by clicking the Save button on the add-in's toolbar. Just like in standard Excel, this will save the selected file under the same name in the same location.
The Save button.

Tip. If you want to save all your changes in all workbooks at once, press Ctrl+A on your keyboard and then click the Save icon.

How to save a file under a new name

If you want to save your file under a new name to a new location, use the Save as option. You can find it if you click on the down arrow to the right of the Save icon:
Select this option to save your Excel workbook as a new file.
It will let you change the file's name and location in the Save As dialog box.

How to sort worksheets

To sort worksheets in a workbook alphabetically, choose a workbook in the list and press the Sort A to Z or
Sort Z to A button on the main toolbar:
Sort worksheets ascending be pressing the Sort A to Z option.
You can also find the same options in the context menu if you right-click on the workbook in the tree:
Select the sorting option that suits you from the context menu.

Tip. If you select several workbooks, you can sort all worksheets they contain at once. To do this, hold the Ctrl key pressed, select the necessary workbooks, and then click Sort A to Z or Sort Z to A.
  1. Select the worksheet in the list.
  2. Right-click on it and choose the Print option from the context menu:
    Choose this option to print your worksheet.
  3. You will see a standard Print dialog box where you can define print settings.
Tip. You can use the Ctrl+P keyboard shortcut to do the same.
Tip. If you right-click on the worksheet in the tree and select the Page setup item from the menu, you will see the Page Setup dialog box where you can customize the page layout before printing your worksheet:
Select Page setup to customize page layout before printing.

How to hide sheets

To hide a worksheet, right-click on it in the list and choose the Hide a sheet option from the menu:
Choose to hide a sheet from the context menu.

Tip. If you right-click a workbook name and choose to Hide a sheet, all worksheets except the last one in the file will become hidden at once.
Note. You can't hide all worksheets within one workbook. A workbook must contain at least one visible worksheet.
Tip. You can hide several worksheets at the same time. To do this, hold the Ctrl key, select the necessary sheets, right-click on them and choose Hide a sheet.

If you want to make your worksheet "very hidden", right-click on it and choose to Make a sheet "very hidden" from the menu. By selecting a workbook name and choosing this option, you can make all sheets except for one "very hidden" at once.
Make a sheet

How to unhide sheets

To show a hidden or a "very hidden" worksheet, right-click on it and choose to Unhide a sheet from the menu.

Tip. You can also select a workbook that contains several hidden worksheets, right-click on it and select Unhide a sheet. This will make all worksheets that it contains visible.

Make sheets visible again with the Unhide a sheet option.

How to copy worksheets from one workbook to another

To copy a worksheet from one Excel file to another, press the Ctrl key and drag the worksheet to another workbook in the worksheets tree.

How to move sheets from one workbook to another

To move a worksheet, just drag it from one workbook and drop to another in the worksheets tree.

How to collapse or expand workbooks

In case you need to check the names of all opened workbooks only or see all worksheets in each opened workbook as well, right-click the worksheets tree and take advantage of the corresponding options in the context menu:
Collapse or expand all workbooks using the context menu.

How to delete worksheets

To delete a worksheet from a workbook, select it and click the Delete button on the add-in's toolbar:
Delete a worksheet using the option on the add-in's toolbar.

Tip. You can find the Delete a sheet option if you right-click on the worksheet as well. Or just press the Delete key on your keyboard.
Use the option in the context menu to delete a sheet.

How to close a workbook

To close a workbook, select it and click the Close button on the add-in's toolbar:
Close a workbook using the icon on the add-in's toolbar.

Tip. You can find the Close a workbook option if you right-click on the workbook as well:
Use the context menu option to close a workbook.

How to export workbook and sheet list

If you need to have a list of all opened workbooks and worksheets in one place, right-click the worksheet tree and pick Export workbook and sheet list from the context menu:
Have a list of all opened books and sheets exported to a new file.
The add-in will create a new workbook and place the list of all currently opened workbooks and their worksheets there:
Het the list of all opened sheets and books in a new Excel file.

Post a comment

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.