Fill

Fill is used to generate multiple values from an existing formula. It extends a user-defined formula to multiple cells with appropriate modifications in the formula. One advantage worth mentioning in SheetKraft's Fill operation is dynamic inclusion of new data into the formula i.e. even if new data are added to the table after defining the Fill operation, they can be operated upon without setting up Fill again.

Fill Down

Sample Data

We will consider a sample sheet containing details of ISINs and its description. Our aim is to find the 4-digit code from ISIN which is unique for the Security Issuer. For eg. BANK OF INDIA SR-4 9.95 BD PERPETUAL FVRS10LAC and BANK OF INDIA SR-II 11.5 BD PERPETUAL FVRS10LAC both will have the code 084A for Bank of India.

Step 1

Create a formula which you want to apply to the whole data. In this illustration, the formula used is =MID(A2,4,4).

Step 2

Click on the Fill command under SheetKraft.

Step 3

A window will appear, then select the cell which is required to be copied downwards.

Step 4

After selecting the cell, click on the marked tab.

Step 5

SheetKraft will automatically select the downward row range, if it matches with your requirement, then go ahead and click on Next otherwise click on the marked tab.

Step 6

Select the range manually or enter the indices.

Step 7

In interpret selection, you will have two options.

1. As non-blank rows: If you select this option, any further data which you append to the sheet can be dynamically operated by the Fill function which you have defined.

2. As is: If you are selecting this option, any new data can't be operated by the previously defined Fill function.

Step 8

Click on OK.

Step 9

Click on Next to finish the process.

Final Result

Specify Number of Rows

Sample Data

We will consider a sample sheet containing details of ISINs and its description. Our aim is to find the 4-digit code from ISIN which is unique for the Security Issuer. For eg. BANK OF INDIA SR-4 9.95 BD PERPETUAL FVRS10LAC and BANK OF INDIA SR-II 11.5 BD PERPETUAL FVRS10LAC both will have the code 084A for Bank of India.

Step 1

Create a formula which you want to apply to the whole data. In this illustration, the formula used is =MID(A2,4,4).

Step 2

Click on the Fill command under SheetKraft.

Step 3

A window will appear, then select the cell which is required to be copied downwards.

Step 4

After selecting the cell, click on the marked tab.

Step 5

Specify the target number of rows directly (height of target range).

Step 6

Enter the number of rows manually or select a cell containing that number and then click on the marked tab.

Step 7

Click on Next to finish the process.

Final Result

Fill Right

Fill Right is used to copy a range of cells rightwards over a range of the specified width. Fill Right works similar to Fill Down, only difference being that it copies the formula from the specified cells rightwards.

Sample Data

We will consider a sample sheet containing the product, interest rate and amount. We want to calculate the Interest Amount in row 5.

Specify Number of Columns

The following shows how to use Fill Right when the numbers of columns to copy in the formula is known.

Step 1:

Create a formula which you want to apply to the whole data. In this illustration, the formula used is =B2*B3.

Step 2:

Type =FillRight.sk in the cell adjacent to the cell containing the formula(here, in C4) and click the fx next to the formula bar to open the Function Arguments pop-up.

Step 3:

In Column_range provide the cell containing the formula (B4) and in width provide the number of columns to which the formula will be copied (here 9).

Result:

Using CountRight.sk:

CountRight.sk can be used in width instead of providing the exact number of columns to add dynamicity.