Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Toggle Settings

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Categorizing Excel Data Start

Toggle settings  
We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook, we will have to do it one at a time.
This powerful tool has been crated to do away with such loss of time.
Advantages include:

Same upper - left cell in all
Let's say you are working in a workbook with 50 sheets and you wish to view the value in the R200 cell of each. It would be a dreary task having to navigate through all worksheets and locate that specific cell in them all, wouldn't it?
With this tool, this would be as simple as:
1. Locate yourself in any worksheet and select the cell to be checked.
2. Press the Same upper -left cells in all button.

That's it. You will view that cell in all worksheets; the selected cell will be viewed the left upper corner.
As simple as 1-2!

Reset Excel's last cells
This utility allows you to save only the part of each worksheet in use, meaning the section containing actual data or formatting.

It may happen that the last cell of a worksheet is beyond the range of your actual used data. This issue may cause you to have a larger file size than necessary, you may experience other unusual behavior.

Clear the excess rows and columns with Reset Excel's last cell and solve these issues.

And many configuration options more. Use this tool as best suits your convenience it's super-intuitive.


Back to Categorizing Excel Data Start

Categorize Excel Data     Secure Payment Options

1 $59.95 USD
2 - 5 Licenses $50.95 USD
6 - 9 Licenses $44.95 USD
10+ Licenses $29.95 USD

Other Features

Extract unique cases
Test the "stratification table sufficiency"
Stratification 1 to 1
Categorize database
Time stratification
Split field
- Split field - By groups
- Split field - By date
Export sheets as...
Sheets manager
Workbooks manager
Freeze | divide panes
Toggle settings

Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site.

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us