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

Freeze | Divide Panes

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


Back to Categorizing Excel Data Start

Freeze | divide panes  
Freeze panes
We sometimes work with models whose information does not fit in the screen. And we may get lost as we navigate throughout the spreadsheet as the headings of our model would no longer be visible.

Divide panes
There may be portions of our worksheet we wish to view at all times. If so, separate those sections as locked portions of data that can be manipulated. This tool can help us in the process of creating, navigating through, editing excessively long models and keeping an eye on them.

Follow these steps:
1st click - Freeze Panes
2nd click - Divide Panes
3rd click Undo Freeze / Divide Panes


Categorize Excel Data   $69.95 Secure Payment Options

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