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.

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.

Ultimate Suite for Excel Professionals
 
 
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard