How do you freeze a row or column?

You can't.

The workaround is to use print view.

Scroll down the topics list for the answer.

There are already numerous posts in the discussions about this (I think one is at the top of page two), the general answer is, nope. Doesn't work in numbers, not yet. You can use the print preview or other work arounds.

Please use the submit feedback option in the Numbers menu to send Apple Programmers suggestions. thats the best way to get them to notice a area that needs work.

Jason

Hello

http://discussions.apple.com/thread.jspa?messageID=5233365&#5233365

http://discussions.apple.com/thread.jspa?messageID=5087147&#5087147

http://discussions.apple.com/thread.jspa?messageID=5298560&#5298560

http://discussions.apple.com/thread.jspa?messageID=5093060&#5093060

http://discussions.apple.com/thread.jspa?messageID=5117690&#5117690

http://discussions.apple.com/thread.jspa?messageID=5130722&#5130722

Yvan KOENIG (from FRANCE mardi 11 septembre 2007 09:26:51)

Hello - I am trying to do the same thing and to discover that Apple "forgot" or didn't include this feature is pretty poor planning on their part. This is the kind of omission that can halt adoption. I'm very disappointed with Apple about this and was excited about using numbers... guess I'll have to keep using Excel until it is fixed.

Andrew

Message was edited by: Andrew Brackenbury

Apple didn't forget it, they didn't want it 🙂 Numbers isn't just another excel clone.
Numbers is for multiple tables on multiple sheets not for Monolithic excel type grids.
The tables are individual graphics and have the number of rows and columns needed for the job in hand, Another job = another table
Have a play with it, there's a huge number of different options.

Yep I've posted exactly the same as this elsewhere. Each worksheet is a blank page, awaiting all sorts of goodies, including lots of little tables.

Do we really want another Excel clone?

The direction Numbers is heading towards - lots of linked tables ala a relational DATABASE - is exciting.

I want Numbers to develop in this direction.

Oh yeah, in case you can't find what you want in the menus of Numbers - look in the Inspector - tons of goodies in there!

And why we can't have the great options of excel plus the great ones of numbers together?
I love the idea of indivual spreadsheet of numbers, really I do... but I want also have the option of freezing rows or columns. Cause the finality is do our work more simply, right?
I know numbers is designed to design (sorry :)) but writing in vertical it's design too and it's not included in numbers.

It's only my opinion.

please see all the other linked topics, and keep searching in the forums here.

You will see that many people have stated that it would have to be coded for each table to be a scrollable entity in itself to implement this. because we can place tables anywhere on a page, including on top of one another, how would you suggest implementing locking the headers on one table while letting the other scroll off the page? It would be visually confusing.

So, for those of us that need to freeze a column, how would we arrange our data in numbers?

Make smaller tables. 6 months rather than a year 🙂
How about hiding the in between columns when necessary.
Repeating the title column periodically
I'm sure you are bright enough to think up different options.

Setup a worksheet to be the part of your data you wish to print.

Don't make this special worksheet just one big table - it defeats the purpose and you might as well use Appleworks or Excel.

You're limited by your own creativity - break out of the "row column" bounds!

I'm sure that I'm bright enough to program my own spreadsheet program actually.

So, numbers is like a program for those people who have time on their hands to be creative with data. I can definitely appreciate that but I guess I was just hoping for an Apple solution or improvement on Excel. I don't quite have the time to be getting creative with the data analysis I need. I simply want results. However, maybe over Christmas I'll have a more thorough play with it and be converted. I hope so because Microsoft products are pretty terrible.

AB

I typically place my sheet in the Freezer at -10C for about 2 hours. Rows and columns are pretty froze by then! 🙂

Just a little Numbers' Humor there...

Regards,

thanks, I needed that today, 🙂
Jason

Hello

Wrong responce WWJD.

The OP was not asking for a frozen sheet, just for a frozen row or a frozen column 😉

Yvan KOENIG (from FRANCE mercredi 14 novembre 2007 18:42:32)