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

Freeze & Divide Panes In Excel

Spreadsheet Consolidator 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

Spreadsheet Consolidator Start

Video Tour  More > Consolidator Demo > Merge Tables Demo > Multisheets Consolidator Demo > Detailed Consolidation

Spreadsheet Consolidator   $69.95 Secure Payment Options

System Requirements: Excel 2000 or above and Windows 98 or above
License Type  Cost
1 $69.95 USD
2-5 $59.45 USD
6-10 $52.46 USD
11+ $34.95 USD

Special! Free Choice of Complete Excel Training Course or Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.


Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

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