🏆 Awards & Recognition
Powerutils has been recognised and featured by India's leading technology publications. Here is the full list of awards and press coverage received:
🥇
Best Software of the Month
PCQuest Magazine · February 2004
Powerutils 1.7 was selected as Best Software of the Month and distributed on the PCQuest cover CD — one of India's most-read tech magazines.
📰
Full Feature Article
IC-Chip Magazine · 2004
IC-Chip (India's edition of Chip magazine) published a large dedicated article on Prasanta Das Gupta and the Powerutils add-in, distributed on their cover CD.
💿
Cover CD Distribution
Think Digit Magazine · March 2004
Powerutils was selected for distribution on the Think Digit cover CD, exposing it to hundreds of thousands of Excel users across India.
💿
Cover CD Distribution
PCQuest & IC-Chip · July 2004
Version 1.8 was featured and distributed on the cover CDs of both PCQuest and IC-Chip in July 2004 — a double-feature month for the add-in.
⭐
5-Star Rating
Multiple Software Review Sites
Powerutils has received 5-star ratings from multiple leading software download and review websites, reflecting the quality and usefulness of the add-in.
💡
About the author: Prasanta Das Gupta built Powerutils as a personal project to solve real problems he faced daily at work. The magazine features were unsolicited — a testament to how genuinely useful the community found the add-in.
✨ 21 New Utilities in Version 1.9
Version 1.9 was released in January 2008 and added 21 new utilities, bringing the total to 99. The undo support was corrected and finalised on 1st March 2008. Below are all 21 new additions:
01
Rows & Columns
Count number of Columns in Selected Range
Quickly find the column count of any selected range without manually counting or using formulas.
02
Range
Convert Formulas appearing as Text to real Formulas
When formulas are stored as text (e.g. imported data), this utility converts them into live, working formulas.
03
Range
Delete Range Names in File
Remove all named ranges from the workbook in one click — useful for cleaning up files before sharing.
04
Range
Format in India Rupees Lakhs Format
Apply the Indian number format (Lakhs and Crores) to any selected range — essential for Indian finance and MIS professionals.
05
Sheet
Copy Multiple Instances of a Sheet within a File
Create multiple copies of a sheet at once — ideal for monthly reporting templates where you need 12 identical sheets.
06
Fill
Put Serial Number in Non-Consecutive Rows with Data
Automatically insert serial numbers only in rows that contain data — skipping blank rows cleanly.
07
Miscellaneous
Break 1st Name & Last Name into Separate Columns
Split a full name column into separate First Name and Last Name columns — handles common naming formats automatically.
08
Date
Convert String Date to Real Date
When dates arrive as text from SAP, ERP, or imports, this converts them into real Excel date values you can use in calculations.
09
Sheet
Unhide All Sheets in Workbook at Once
Excel only lets you unhide one sheet at a time. This utility unhides every hidden sheet in the workbook in a single click.
10
Mathematics
Give Data for a Range Criteria
Extract and summarise data based on custom range criteria — generated in a separate file for easy review and distribution.
11
Fill
Copy Values to Empty Cells Above
When data from merged exports leaves blank cells above values, this fills them up — the reverse of the standard fill-down operation.
12
Range
Put Bullets in Front of Items (Multiple Styles)
Add bullet points to list items in Excel — choose from multiple bullet styles, similar to Word's bulleting feature.
13
Add
Add Blank Spaces at End of Text to Make Specific Size
Pad text cells with trailing spaces to reach a fixed width — useful for fixed-format exports and ERP data preparation.
14
Sheet
Create Clickable Index Sheet with All Range Names
Automatically generates a navigation sheet listing all named ranges as clickable hyperlinks — perfect for large workbooks.
15
Miscellaneous
Refresh Pivot Tables in All Sheets in Current Workbook
Refreshes every Pivot Table across all worksheets in one click — no more manually updating each table after data changes.
16
Audit
Put External Links in a New Sheet
Lists all external file links from the workbook into a dedicated sheet — essential for audit trails and file dependency checking.
17
Audit
Find All Errors in Worksheet & Put in Separate Sheet
Scans the entire worksheet for formula errors (#N/A, #REF!, #VALUE!, etc.) and lists them with their locations in a new sheet.
18
Columns & Rows
Filter Data in a Column Based on Background Colour
Extract only the rows that have a specific background colour — something Excel's standard filter cannot do by colour in most versions.
19
Columns & Rows
Filter Data in a Column Based on Font Colour
Extract rows matching a specific font colour — particularly useful when data has been colour-coded for status or category.
20
Columns & Rows
Move or Copy Rows Based on Background or Font Colour
Move or copy entire rows to another sheet or location based on their background or font colour — powerful for colour-coded workflows.
21
Range
Sort Data by Background or Font Colour
Sort any data range by cell background colour or font colour — the signature feature that Excel users have been asking for since colour-coding became popular.
📂 All 11 Utility Categories
All 99 utilities in Powerutils 1.9 are organised into 11 logical categories, accessible directly from the Powerutils menu in the Excel ribbon. Here is the complete overview of every category and the types of utilities it contains:
🔤
Text
Case conversion & text cleaning
→
Convert selected text to UPPERCASE
→
Convert selected text to lowercase
→
Convert selected text to Proper Case
→
Remove extra spaces from text cells
→
Remove non-printable characters
→
Reverse text string in cells
📋
Range
Range operations & transformations
→
Transpose a range (flip rows and columns)
→
Join data from two columns into one
→
Split one column into two based on delimiter
→
Remove duplicates from a range
→
Convert formulas to values in place
→
Convert text appearing as number to real numbers
→
Delete all empty rows in a range
→
Delete all empty columns in a range
→
Format in India Rs Lakhs format New
→
Convert Formulas appearing as text to real formulas New
→
Delete Range Names in File New
→
Put Bullets in Front of items New
↕
Columns & Rows
Row and column manipulation
→
Insert N blank rows after every row
→
Delete every Nth row in a range
→
Count number of columns in selected range New
→
Sort data by Background Colour New
→
Sort data by Font Colour New
→
Filter data based on Background Colour New
→
Filter data based on Font Colour New
→
Move or Copy Rows by colour New
🖊
Fill
Filling blanks and generating sequences
→
Fill blank cells down with value above
→
Fill blank cells up with value below
→
Put Serial Number in Non-Consecutive rows with data New
→
Copy Values to empty Cells above New
📅
Date
Date conversion and arithmetic
→
Convert dates to text in various formats
→
Calculate difference between two dates in days / months / years
→
Add or subtract N days / months from a date range
→
Convert String Date to Real Date New
🔢
Mathematics
Number conversion and calculation utilities
→
Convert Numbers to Words in Indian Rupees format
→
Round all numbers in a range to N decimal places
→
Change sign of all numbers in a range (positive to negative and vice versa)
→
Give data for a Range Criteria New
📑
Sheet
Workbook and sheet management
→
Create a clickable index sheet of all worksheets
→
Delete all blank sheets in a workbook
→
Protect all sheets in a workbook at once
→
Unprotect all sheets in a workbook at once
→
Copy Multiple Instances of a Sheet New
→
Unhide all Sheets in Workbook at Once New
→
Create Clickable Index Sheet with all Range Names New
➕
Add
Adding prefix, suffix, and padding to text
→
Add a fixed prefix to all cells in a range
→
Add a fixed suffix to all cells in a range
→
Add blank Spaces at end of Text to Make Specific Size New
🔍
Audit
Workbook auditing and error detection
→
List all formulas in the worksheet to a new sheet
→
Put External Links in a New Sheet New
→
Find All Errors in worksheet & put in a Separate Sheet New
🛠
Miscellaneous
Colour tools, cell identification, and productivity utilities
→
Colour cells which contain numbers
→
Colour cells which contain text
→
Colour cells which contain formulas
→
Colour cells which are blank
→
Break 1st Name & Last Name into Separate Columns New
→
Refresh Pivot Tables in all Sheets in Current Workbook New
📊
Chart & Format
Chart and cell formatting utilities
→
Apply consistent formatting across all charts in workbook
→
Copy cell format from one range to another
→
Remove all formatting from selected range
📥
Ready to use all 99 utilities? Download Powerutils 1.9 — free, no registration required, ~370 KB zipped. If you downloaded before 1st March 2008, please re-download to get the corrected undo support.