Installing the Choose Sheetxla Addin

In a workbook containing multiple worksheets, moving between worksheets to select the one you need is not a convenient task. There are two techniques for selecting a worksheet you need:

4 Press <Ctrl+Page Down> or <Ctrl+Page Up> to move to the next or previous worksheet.

4 Right-click one of the arrows in the worksheet's horizontal scroll bars (in the leftmost lower corner) and select a worksheet from the displayed menu.

Selecting a worksheet from the worksheets menu is useful only if there are less than 10 to 15 worksheets in the workbook.

The ChooseSheet.xla add-in enables you to easily select a specific worksheet from a list of sorted worksheets in ascending order.

This add-in displays the list of worksheets in the active workbook (in this example it is Financial Statements.xls) in ascending order (as shown in Figure 1 -8), and allows you to easily find and look into the worksheet before choosing it. Clicking a worksheet in the list displays a preview; clicking it again selects the worksheet itself. Worksheets can also be hidden and displayed, as required.

Microsoft Excel - Financial Statements

File Edit View Insert Format Tools Data Window Help j^yll mMa 1 & 1

Choose Sheet r. Workbook Name - Financial Statements.'^;

Worksheets List

11 General Details

12 - Workshec

13 - Pararrietr:

14 - Month? I..i 15- BS, IS Le' 13 ■ Notes Lis1 21 - Trial Balat 31 - Balance E 41 ■ Income S1 51 - Cash Fiov 61 ■ Notes

93 - Trial Balar

94 - Trial Balar

E3i r. Workbook Name - Financial Statements.'^;

11

General Details

;

12

Worksheets List.

13

Farametrs.ir Calculations

14

Months Liit£

15

BS, IS Level

1G

Notes List

21

Trial Balances Data

31

Balance Sheet

41

Inconi;; Statement

51

Cash Flow

61

Notes'

31

Tiial Balance (Original)

32

T rial Balance Adjustments

33

Trial Balance Updating

34

Trial Balance Audit

1 I

www.ExcelTip.coin

V Sort

Print

Hide

Unhide

V Sort

Print

Hide

Unhide

Figure 1-8: Choose Sheet Dialog Box

Figure 1-8 displays the Choose Sheet dialog box, which contains the list of worksheets. In the background, you can see the worksheets list in worksheet 12 — Worksheet List. When the add-in has been installed, an icon is added to the regular toolbar, which can be clicked to display the Choose Sheet dialog box.

^ To install the add-in:

1. Go to www.exceltip.com/xls and download the Add-in from the Financial Statements.xls book page.

2. Save the downloaded ChooseSheet.xla file in any folder.

3. From the Tools menu, select Add-Ins, and click Browse.

4. Locate and select the ChooseSheet.xla file.

6. In the Add-ins available box, select the ChooseSheet.xla check box.

Chapter 1

0 0

Post a comment