I have a large spreadsheet and I want to scroll up, down, left and right without the need to go up and down to find the name of the column or row where the information goes into.
In Excel you lock a column or row just as easy but in numbers I have looked everywhere and don´t find an answer to this (otherwise) simple procedure.
Thanks tho anyone who can help me.
MacBook Pro, iOS 6.1.3
Hi Laura,
The commands you are looking for are "Freeze Header Rows" and "Freeze Header Columns", both found in the Table menu.
To use them, you must first convert the rows and columns you want to keep visible as Header Rows and Header Columns. You can define up to five of each. Rows must be at the top of the table and columns at the left, and multiple header rows/columns must be contiguous.
Be aware that the conversion is not (easily) reversable, and that multiple headers (and footer rows) tend to slow large tables significantly.
To convert an eligible row, hover the mouse over the row reference tab, then click the triangle when it appears. If the row is eligible for conversion (ie. if it is the top non-header row on the table, and is in the top five rows), you will see the option to "Convert to Header Row, seen below for row 2:.
Regards,
Barry
You can lock a whole table but not just some selection of cell(s) row(s) and column(s). This means you should store things you don't want a user to touch in one table and data entry or user touchable items in another table that is not locked.
You can download the free users guide and the functon reference by visiting the site:
Thank you Barry and Wayne for your help!
How do I lock columns and rows in numbers?
