I was following this thread and Barry's comment because I need to freeze more than 5 Rows:
Freeze a row in Numbers - Apple Community
I have currently got the max 5 rows frozen already but I want to freeze 6 top rows so the white row is what the dates etc will be cascading into as you scroll down.
When I select Header Row 1 on my menu there is no way to "add another row" as suggested in the above link?
Cheers
MacBook Pro 15″, macOS 13.0
Yes, me too when I tried the border feature out on a new blank Table it's all good.
On this Sheet with one large table, the red border doesn't appear anywhere else other than on the far left and between Rows 208 and 273.
(I haven't edited these middle rows and problems like the cell referencing:
Cell Reference Ranges change from Numbers… - Apple Community
occurred as I did copy and paste (intermix) some of Rows from the very top of the table and paste them again at the bottom and vice versa and also altered the ascending / descending data option.
Cheers, that's a good idea, using a table border would free up that extra needed column to freeze.
When I went to do that though, I couldn't see any table border being generated, so I went to red to try and find it. For some reason it's painted the red border only on the left hand side of the table and midway down the 333 rows it has?
Maybe you messed with the cell borders at some point in the past. If you change a cell border, it will take precedence over the table border. Select that column of cells and put the cell borders to "default style". Maybe that will clear it up.
It looks like you are using columns A & B and rows 1&2 (and probably the columns on the far right side and rows at the bottom) as a decorative border. If you did away with that, or at least one of the two of them, you would have all the frozen headers you need. Header columns and rows serve a special purpose in a table. Decoration is not the intended purpose.
You can outline the entire table with a thick band of color or grayscale without using any columns or rows to do it. It is called a table border and is in the Table tab when the table is selected.
No, it was created in Numbers.
there was some copy and pasting of the first 10 to 15 rows of data, where I would take the bottom rows and paste the data into the top and vice versa but I haven’t edited (copy/pasted) the range of rows from around row 20 to 208 for example so I’m not sure why this has happened?
Hi Bardonicloud,
Was "Perfect 👌 Thank you!" the "best answer" to your question?
Marking a post as the "Best answer" places a copy of that post at the top of the discussion thread, immediately below the the opening post, containing the question itself, where it can be seen by other users looking for a solution to a similar question.
Badunit's May 5 post, to which you were replying, is the one that actually contains the information that apparently contained a solution to your issue, and is the one that should have received the "Best answer" tag.
You can't move that tag once it has been applied to a post, but you can mark Badunit's post as "helpful," which will make that answer a bit easier to be found.
Regards,
Barry
Perfect 👌 Thank you!
I have no idea. Looks fine here when I try it. What does it look like if you zoom in?
I also just noticed the red border that is on the left is also matched by the same positioned red border on the far right hand side of the table? Odd!
Did your tables originate in Excel by any chance? If so, keep in mind that the data comes over to Numbers but there can be mysterious things in the formatting.
SG
How to Freeze more than 5 Rows
