How to create a new workbook or worksheet

  1. Open the Workbook Manager pane by clicking on its iconWorkbook Manager icon.
  2. There are three ways you can create a new workbook. You can click on the New button on the main toolbar of the add-in: Click on this button to add a new workbook You can also create a new workbook by right-clicking on the area with the workbooks tree and selecting New… ->New Workbook from the menu. Choose the New Workbook option to create a new workbook Or you can use the Ctrl + N keyboard shortcut to get a new workbook.
  3. To create a new worksheet, click on the down arrow next to the New button. Click this button to create a new worksheet You will see a menu, in which you can select "Worksheet": Select the Worksheet option from the menu to add a new Excel worksheet Another way of creating a new worksheet is right-clicking on the area with the workbooks tree and selecting New… -> Worksheet from the menu. Use this option from the context menu to get a new worksheet You can use the Ctrl + Alt + W key combination to get the same result.
  4. To create a new worksheet from the worksheet template, click on the arrow next to the New button and select the necessary worksheet template from the drop-down list: Click on this button to create a new template worksheet Select the necessary worksheet template from the list You can also create a new worksheet using the worksheet template if you right-click on the area with the workbooks tree, go to New… option and select the worksheet template you want from the list. Choose the necessary worksheet template from this context menu

How to open a workbook

  1. Click on the Open button on the add-in's toolbar to open a workbook. You will see a standard Explorer window where you can browse for a workbook. You can also open a workbook by right-clicking on the area with the workbooks tree and selecting "Open" from the context menu. The keyboard shortcut you can use is Ctrl + O. Click this button to open Excel Workbook
  2. To open recently used workbooks, click on the down arrow to the right of the Open button See recently used workbooks in this list Or right-click on the area with the workbooks tree, go to the Open… option and choose the necessary workbook from the list.

How to rename worksheets and workbooks

  1. To rename your worksheet or workbook, select it in the list and click the Rename button on the main toolbar or right-click on the worksheet (workbook) and select the Rename option from the context menu. You can also use the F2 hotkey. The Rename button Select this option to rename your worksheet or workbook
  2. After you type a new name press Enter to save it. Press Enter 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 pressing the Save button on the add-in's toolbar. Just like in standard Excel, this will save the selected file(s) under the same name(s) in the same location(s).

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

How to save a file under a new name

If you want to save your file under a new name to a new location, you should use the Save as option. You can see this option if you click on the down arrow to the right of the Save button.

The Save button

It allows you changing the file's name and location in the Save as dialog box.

Select this option to save your Excel workbook as new file

How to print a worksheet

  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, in which you can define print settings. You can use the Ctrl + P keyboard shortcut to do the same.

    If you right-click on the worksheet in the tree and select the Page setup item from the menu, you can customize the page layout before printing your worksheet. You will see the Page setup dialog box. Select the Page Setup item to customize page layout before printing

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 by pressing the Sort A to Z option

You can also choose the Sort A to Z or Sort Z to A option from the menu if you right-click on workbook in the tree.

Select the sorting option that suits you from the context menu

If you select several workbooks, you can sort all worksheets they contain at once. To do this hold the Ctrl key, select the necessary workbooks and then click "Sort A to Z" or "Sort Z to A"

Sort worksheets ascending by pressing the Sort A to Z option

How to hide sheets

  1. To hide a worksheet(s), right-click on it in the list and choose the Hide sheet(s) option from the menu. Choose the option to Hide worksheets from the context menu
  2. 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 sheet(s). But note that you can't hide all worksheets within one workbook. A workbook must contain at least one visible worksheet.
  3. If you want to make your worksheet(s) "very hidden", right-click on it and choose the Make sheet(s)" very hidden" item from the menu. By selecting several worksheets and choosing this option you can make them all "very hidden" at once. Make Excel worksheet very hidden by choosing this option

How to unhide sheets

To show a hidden or a "very hidden" worksheet, right-click on it and choose the Unhide sheet(s) option from the menu. By selecting several worksheets you can unhide all of them at once.

You can also select a workbook that contains several hidden worksheets, right-click on it and select Unhide sheet(s); this will make all worksheets that it contains visible.

Select the option to unhide sheets to make them visible

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 delete worksheet(s)

To delete a worksheet from a workbook, select it and click the Delete button on the add-in's toolbar. You can find the Close Workbook(s) or Delete sheet(s) option if you right-click on the worksheet as well. Or you can just press the Delete key on your keyboard.

Select Close Workbooks or Delete sheets from the context menu

If you select several worksheets, you can delete them all at once.

Note. If you select a workbook and click the same Delete button, it will close the workbook.

Add a table of contents in Excel

The Table of Contents for Excel tool takes one click to create a table of contents with hyperlinks to all sheets in the current workbook. You can find the tool in Ultimate Suite for Excel.

Adding a TOC is as easy as 2 clicks.

  1. Select the top cell for the table of contents in your workbook.
  2. Click on the Table of Contents icon under the Ablebits Utilities tab in Excel.
How to add a table of contents to your workbook Create a table of contents to your workbook

You can quickly create a table of Contents on each sheet to easily navigate back and forth.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our forum
 

Please remember that we work from 8am to 4pm GMT, this is 4:00am to 12:00pm EST,
1:00am to 9:00am PST, and our public holidays may differ from yours.

Collection for Outlook
Automatically CC or BCC recipients
Never forget to copy your colleagues on some or all outgoing messages
Reply with email templates
Create your collection of email templates to avoid typing the same text again and again
Check emails before sending
Configure your rules to prevent "Oh, no!" after sending an email
Never forget to hit Reply All
Always remember to select Reply All on a multi-recipient message
Prevent unintended replies to all
Get an alert when you're about to reply to all recipients of an email
Never miss really important emails
See an immediate notification when an urgent message arrives at your in-box
Analyze email headers
Get a really quick access to email headers to fix some common mail problems
Optimize your email timing
See sender's time zone to send timely emails when you correspond with people overseas
Add-ins Collection for Outlook
Boost your in-box productivity!
See more