Creating a Worksheet

To add a worksheet to the active analysis file:

Step01Select the Navigator Position

Select the position in the Analysis Navigator where you want the new worksheet to appear. To make it the first sheet in a folder, select the folder itself. Otherwise select the sheet that you want the new sheet to follow. In the example below the new sheet will appear after Custom Worksheet 2 and before Custom Worksheet 3.

CreateSheetSelectNavPos

Step02Select the Create Sheet Command

Select Tools | Create Sheet. ValuSource Pro will open the Create Sheet Dialog Box.

Step03Enter the New Worksheet's Title

Enter the title for the new worksheet in the input box labeled "Enter a unique title". If the title is already in use, you will be prompted to enter a different title when you select the OK button.

EnterUniqueTitle

Step04Enter the Number of Rows and Columns

Enter the number of rows and columns that you want to appear in the worksheet. You can modify the sheet later by editing the analysis file directly in Excel.

EnterNumberRowsColumns

step05Select OK

Click on the OK button. ValuSource Pro will close  the Create Sheet Dialog Box and add the new worksheet.