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
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:
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... :/