Powerutils ver 1.9 Help

 Top  Next

New to this Version 1.9

 

Powerutils has now become a highly used addin and with this version it has grown in strength by having 21 more powerful programs added with the aim of saving your valuable time while working in excel. The total number of programs are now 99 in this version.

 

The New programs are:

 

 

Description

MenuHead

1

Count number of Columns in Selected Range

Rows & Columns

2

Convert Formulas appearing as text to real Formulas

Range

3

Delete Range Names in File

Range

4

Format in India Rupees (Lakhs & Crores) format, it is dynamic.

Range

5

Copy Multiple instances of a sheet within a file.

Sheet

6

Put Serial Number in Non consecutive rows with data.

Fill

7

Break 1st Name & Last Name

Misc

8

Covert String Date to Real Date

Date

9

Unhide all Sheets in workbook

Sheet

10

Convert a set of data into Data table with range.

Mathematics

11

Copy Values to empty Cells above

Fill

12

Put Bullets in Front of items like in Word with various

 

 

items as per specified selection

Range

13

Add blank Spaces at end of Text to Make it Specific size

Add

 

Create Clickable  Index Sheet with all Range names

Sheet

 

Refresh Pivot table in all sheet in current workbook

Miscellaneous

16

Put External Links in New sheet

Audit

17

Find All Errors in worksheet & put in a separate Sheet

Audit

18

Filter Data in a Column based on Background Color

Column and Rows

19

Filter Data in a Column based on Font Color

Column and Rows

20

Move or Copy Rows based on background or font Color

Column and Rows

21

Convert a number to Indian Rupees as text =num2text(value)

Number

 

 

Some of these new programs do not have undo features built in yet so please save your data before running any program which manipulates your original data. However most of this programs do not touch your original data but creates new columns of data. It is strongly advised that you print the help file and read it so that you properly understand how powerful this Addin is. Also practise a few times to get the hang of the programs.

 

 

New to Version 1.8

There are now 78 Utilities which is 24 more than the earlier version. This software was distributed in all the Computer Magazine CD's in Aug/Sep 04. Powerutils 1.7 was featured in IC Chip (Feb04 - page 31) , it was voted as Best Software of the Month in PC Quest (Feb'04) and also distributed in Think Digit (April'04).

 

:-

1. Keep your Favorite Excel File List clicks away. 

2. Breaking large Excel Text file greater than 65000 lines to smaller files.  

3. Convert Indian Rupees to Text.

4. Renaming Open File.

5. Inserting Blank Rows & Columns after n rows or n columns.

6. Create Hyperlinked Sheet of all Files in a directory .

7. List all Installed Font with the name & user defined sample.

8. Show or Replace All types of errors with anything.

9. Copy Formula without Change of Address.

0. Sort on Cell/Font Color in 2 steps.

.............and many more..............

 

Achievements of Powerutils 1.7

 

Powerutils 1.7 features in IC Chip of Feb'04 with a large article on page 31-32.

PC Quest voted it the best software of the month (Feb'04) and it was also distributed in the mindware CD of Digit (April'04).