Difference between Freeze and Split in Open Office Calc

Asked By Carolyn E Skipper 20 points N/A Posted on - 04/04/2012

I have Open Office Calc installed in my computer, it’s also a spreadsheet software equivalent to MS Office Excel . I just want to know what is the difference between Split and Freeze functions in Calc. I used to use Freeze but I can't really tell the difference between the two. I don't have Excel right now installed but I'm pretty sure Excel has Freeze and Split as well, but then again what's the main difference?

• Status: Open
• Question Views: 1857
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Pelayo Lyjputo

Go To Solution

Best Answer

Best Answer

Answered By Pelayo Lyjputo 0 points N/A #133355

Difference between Freeze and Split in Open Office Calc

Whenever a user is working on a huge spreadsheet, it will be very hard to read it and understand the contents of the spreadsheet. If you scroll anywhere to right or down, you will drop  the headings that are placed on top and on the bottom on the left side of your spreadsheet. And if you lose the headings, it will be difficult to trace the column or row that you wish to view. 

The major difference between the Freeze and Split functions are, it can be use to divide the window into manifold resized panes with a view of your worksheet. In Split function, you can see various outlying worksheet parts at once while in Freeze function, you can only view two parts of your worksheet. This function is used to keep the rows and columns visible. And it can also be used on top row freeze or first column freeze. 

 

About Pelayo Lyjputo

Questions
2

Answers
12

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/17/2012
• Question Category: MS Excel

Answered By Anthew Staw 0 points N/A #133356

Difference between Freeze and Split in Open Office Calc

The difference between them is that when you select freeze what it actually does is divide the view of the excel window into four equal parts but the thing is that the division is permanent and you can’t select or choose specific areas to view. While in split what it actually does is put a vertical and horizontal line on the excel window so that you can select a specific view.

Say for example the first row is your headings e.g. (POWER(A1),BILL(B1), and etc.) so what you’ll do is drag the horizontal split below the headings, then scroll down on the lower half. What it actually does is create a separation line which makes the headings visible every time you scroll down.

Try pressing freeze panes then the split becomes permanent. Hope this helps. 

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/02/2012
• Question Category: MS Excel