A new sub forum, 'Tips and Tricks', has been added to the Zoho Sheet forum and we are planning post tips and howtos related to Zoho Sheet in this sub forum. The first topic deals with Freeze Panes.
When you have a large table of data spanning multiple rows and columns, it becomes difficult to keep track of which data you are looking at as you scroll down or to the right. The 'Freeze Panes' functionality solves this by allowing you to lock the row and column headings in place. These locked rows and columns will always be displayed even while scrolling down/right the spreadsheet.
Using Zoho Sheet, you can freeze up to the first 5 columns and/or the first 5 rows. Here is how you will need to apply Freeze Panes under different scenarios.
To freeze the first 2 rows, you need to select the 3rd row and then apply Freeze Panes.
To freeze the first column, you need to select the 2nd column and then apply Freeze Panes.
To freeze the first 4 rows as well as the first 2 columns, you need to click on the cell below row 4 and to the right of column B, i.e., cell C5 and then apply Freeze Panes.
The basic idea is that you should select the first cell from where you want the scrollable area to start. The rows and columns above and before this cell will be locked in place.
You can apply Freeze Panes either from the 'More' menu or from the right click context menu. Here are a couple of screenshots depicting how to access the Freeze Panes functionality.
And finally, here is a video of Freeze Panes in action:
'Freeze Top Row' and 'Freeze First Column' options have been recently provided to enable you to freeze the top row or the first column quickly irrespective of the current active cell.
Would you please provide a sane way to freeze rows/columns? I wasted a good amount of time to get it work and couldn't, then had to ask someone, who pointed out this page.
Here's what's wrong: I can see that the default options I have are to freeze only 1 row/column, so I select the first two rows and look at my options again (on the toolbar, or using the context menu): now I see the old "Freeze first row" option again. That's just wrong! It should be "Freeze first two rows".
Also, another basic rule of modern UI design is that "change happens to the highlighted area", because that's where the user is focusing on! So, when I highlight only the second row and say "Freeze", it should freeze the first two rows, not just the first one.
Can you provide one good reason to not follow the common sense here? Why your "basic idea" should make sense to me here? How are you communicating that basic idea to me? Maybe I'm missing something obvious here... :/
Leave a comment on zwnj's reply
Change topic type
Link this topic
Provide the permalink of a topic that is related to this topic