Filling data Tools

Fill empty cells with user selection                This will fill the selected range with whatever value you enter. For example you have a worksheet with the Salary of 1000 employees under various heads and few of the cells are blank . Suppose you have a worksheet with a data like this.

Now you want to put the word Nil wherever there is not payment. First select the correct range then use this program. The program will take a confirmation that the range selected is correct & small then give a Edit Box where you type in the Characters you want to fill with. In this case we will use "Nil". Once the program runs the output will be like this.

Copy Values to empty Cells below                 This program is specially useful after using the Sub Total function in Excel. After you do a Sub total based on the Key column and the totals of specified columns are obtained, you will find some Text data not appearing in the sub total rows which might be critical for your working. Use this function to copy the data down to blank rows ."

Copy Values to empty Cells above                 This program is similar to the above one. but in this case the data is copied to blank cells above.

Quick numbering of rows                This may not be a great time saver but it can reduce an element of irritation from your head. Suppose you have to Number a column of data from say 1 to 300. Just select the starting cell and select this program. It will ask you for the starting serial number and ending serial number and it will put the serial numbers down the rows.

Quick numbering of Columns This is similar to above utility, suppose you have to Number a row of data from say 1 to 125. Just select the starting cell and select this program. It will ask you for the starting serial number and ending serial number and it will put the serial numbers across the row. This utility can be used for finding the offset column number for Vlookup formula....think about it.

Put Serial Number in Non consecutive rows with data.

A very useful program which can put consecutive serial numbers in a data base which has gaps in between and at the same time the gaps are uneven.

Suppose you have a data like this

To put serial numbers against each of them use this program to get an output like this. You can even start fro any number other than one.