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:
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:
- Click on the down arrow next to the New Workbook icon and choose the corresponding option from the drop-down list:
- 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:
- 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:
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:
The keyboard shortcut you can use for the same result here is Ctrl+O.

How to rename worksheets and workbooks
- Select the worksheet or workbook of interest in the list and click the Rename button on the toolbar:
Or, right-click on the worksheet (workbook) and select the Rename option from the context menu.
Tip. You can also use the F2 hotkey. - After you type a new name, press Enter to save it:
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.
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:
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:
You can also find the same options in the context menu if you right-click on the workbook in the tree:
How to print a worksheet
- Select the worksheet in the list.
- Right-click on it and choose the Print option from the context menu:
- You will see a standard Print dialog box where you can define print settings.

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:
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.
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.
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:
How to delete worksheets
To delete a worksheet from a workbook, select it and click the Delete button on the add-in's toolbar:

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

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:
The add-in will create a new workbook and place the list of all currently opened workbooks and their worksheets there: