Organize Numbers Tables, Headers, Rows and Columns

Platform and verification boundary

This walkthrough targets Numbers 15.4 for Mac, as identified by Apple’s retrieved guide metadata, reviewed on 19 October 2026. The Mac sidebar/menu instructions do not establish the same controls on iPad, iPhone, or Numbers for iCloud. Older Mac editions can differ. Native Numbers was unavailable to the author: procedures were checked against Apple documentation and fixture expectations were independently calculated; no app execution or product screenshots are claimed.

Build a readable stock table on a named sheet, distinguish body rows from headers and footers, and add a new item without converting existing data into a heading.

Create the Stock fixture

Choose File > New and the Blank template. Double-click the sheet tab to give it the name below, and double-click the table title to rename it. If the title is hidden, Control-click row 1 and choose Show Table Title. Use Format > Table to set one header row, zero header columns and zero footer rows unless instructed otherwise. Enter each fixture at the stated cell address; extra empty rows may remain. All examples are invented practice data.

Name the sheet Warehouse and the table Stock. Use four columns and five rows initially. Drag the bottom-left row control and top-right column control to set those counts while unused cells are empty. Enter:

Row	A: Item	B: Units	C: Bin	D: Note
1	Item	Units	Bin	Note
2	Clips	12	A1	Small carton
3	Folders	8	B2	Blue covers
4	Labels	20	C1	Keep dry
5	Total	=SUM(B2:B4)	empty	empty

The expected total is 40. The Bin entries are labels within cells, not instructions to navigate to those addresses.

Designate and freeze headers

1. With Warehouse active, click Stock and open Format > Table.
2. Under Headers & Footer set one header row, one header column and one footer row. Row 1 becomes the header, column A the header column, and row 5 the footer. Existing content stays in those rows; these settings do not insert new blank rows.
3. Confirm the footer still contains Total and the total remains 40. If Labels has become the footer, the table has the wrong row count: restore the five-row fixture before continuing.
4. In the header-row pop-up menu choose Freeze Header Rows; in the header-column menu choose Freeze Header Columns. These settings apply to this table’s header areas, not an arbitrary row in the sheet canvas.

Apple’s header and row guide supports up to five header rows, five header columns and five footer rows. A frozen heading is a navigation aid, not data protection.

Resize and position the table

1. Select a cell in column D. Under Format > Table > Row & Column Size, adjust Width until Small carton is readable. The whole column changes width, not just the selected cell.
2. Open column A’s letter menu and choose Fit Width to Content. Use a row-number menu’s Fit Height to Content if a row is too short.
3. Select body rows 2–4 and choose Table > Distribute Rows Evenly. Check that all three have equal height and the values are unchanged.
4. Click the table, then drag its top-left table handle to a clear part of the canvas. Do not drag a selected cell, which is a different operation. Moving the object preserves its row/column count.
5. Open the arrow on the Warehouse sheet tab and choose Stock to navigate back to it. Double-click a sheet tab to rename a sheet when organizing a larger workbook.

These operations follow Apple’s row/column resizing guide, table movement guide and sheet organization guide. A sheet can contain multiple independent table objects; keep their names distinct rather than treating the whole canvas as one grid.

Add one stock item and verify the footer

Open the row-number menu for row 4 and choose Add Row Below, inserting a body row before the footer. In the new A5:D5 enter Envelopes, 5, D3, Flat pack. The Total footer is now row 6. Explicitly set B6 to =SUM(B2:B5) so this tutorial does not rely on an assumed reference expansion. Expect 45. If you later change the Envelopes quantity to 7, expect 47; restore it to 5 for the final file.

Save and check the finished layout

Choose File > Save and save Numbers-Stock-Final.numbers in your local Numbers Practice folder. Reopen that file with Warehouse active. Confirm four body items, one footer, total 45, readable notes and the two freeze settings. Do not reset the finished workbook.

For a larger scrolling test, first use File > Save As to create Numbers-Stock-Scroll-Test.numbers. Add empty body rows before the footer, then scroll enough that the header would otherwise leave view. Check the frozen headers remain visible while that table is in view. In this copy, restore the four-item fixture and the footer formula explicitly if you want to continue calculations. Never use scrolling as evidence that content is locked.

Troubleshooting

A missing last item often means the existing last row was converted into a footer prematurely. Fix the table shape before assigning roles. A resize handle changes physical size, whereas the edge row/column controls change the number of cells. If fitting content makes a column unexpectedly wide, inspect its longest entry. Avoid deleting rows by dragging through nonempty content; preserve the final file and experiment in the separate copy.

Sources and practice-file setup

The source scope is Add or remove rows and columns in Numbers on Mac. The cited Apple guide pages identify Numbers 15.4 in their metadata. Create a spreadsheet, name the sheet, name the table, set headers and table rows and save a named spreadsheet or separate copy support the common setup and save steps.