7112 Views 10 Replies Latest reply: Sep 13, 2008 10:49 PM by Mursaydees
It's very necessary, IMO. Try having a large table of data that you're entering. As you fill in the table down, your top title row has now scrolled off the top and you have no idea which column you are in.
Same thing if the window scrolls to the right, you have no idea which row you are in.
Sure you can change the scale to print, then you have a printout that you need a magnifying glass to read.
While Numbers doesn't allow you to freeze panes that include multiple rows or columns, if all you want to do is keep track of which column or row you are viewing, create a table that has a header row and a header column -- or add them if an existing table doesn't have these headers. Then choose Show Print View. You will then see that the header column and header row are included at the top and left of every page.
Here we are end users trying to help end users.
Is it really useful to repeat for the hundred's time the same grind?
Freeze panes is not available PERIOD
If you want it:
_Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
Then, cross your fingers, and wait _at least_ for iWork'09
Yvan KOENIG (from FRANCE mercredi 4 juin 2008 10:16:46)
What a bummer! I cannot understand why they would not provide this function, that I would think is an essential element of all spreadsheets. Simplicity is a beautiful ting, but ... wow! What were they thinking? Here I am, HIGHLY motivated to not have to use Microsoft products, and highly loving Apple products, and I can't imagine how I would use this product. I have a very simple cash flow spreadsheet, and I just need to put values in for "rent" in each first of the month column .. and I can't do it without scrolling up to the top every time? That's ridiculous.
Hi to jt519, guyvitetta, and ChrisB1,
Welcome to Numbers discussions.
Freezing columns/rows is arguably the most asked question in this forum. Prior to posting that question using this forums search feature would have provided you the answer to your question. My suggestion is to first use Search Discussions.
Follow Yvan's post contact Team Numbers request to have freeze columns/rows in the next version. They won't answer however, along with many others that have sent them that same request yours will be there as well. The more the merrier, maybe in the next version it will be added perhaps.
These Discussions are enduser helping enduser, not Apple employees answering questions. Discussing whether something is important or unimportant, a reason why something was not included or was included in a application is a exercise in futility. Voice concerns to the Numbers Team—many times I have sent them my requests as well.
Again, welcome to Numbers Discussions, have fun here.
If all you need is the header when putting in entries at the bottom of the table, create a second table with just the headers and put it at the bottom of the primary table. As you add entries to the primary table, it'll push the new "header table" down.
Doesn't help with entries in the middle of the sheet, but would in this one case.