iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
In Numbers on Mac, select a row by clicking its number or a column by clicking its letter, then use the label’s arrow menu for interior changes. Use the table-edge controls to add rows or columns quickly. To keep data but remove it from view, hide the selected rows or columns rather than deleting them.
Apple’s current Numbers User Guide covers Numbers 15.4; the version installed on your Mac may differ, and interface labels can change between releases.
Select rows or columns first
- Open the spreadsheet and click the table you want to edit.
- Click a row number along the left edge to select a row, or a column letter along the top to select a column.
- To select adjacent rows or columns, drag across their labels. To select nonadjacent ones, hold Command while clicking each label.
Once selected, use the row-number or column-letter arrow menu to add, delete, hide, or unhide items. Apple describes this selection method in its row and column selection instructions.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →How do I add a row or column?
Add at the table edge
Click the Add Row button at the bottom-left of the table to add one row. Drag the button to add multiple rows. Click the Add Column button at the top-right to add one column, or drag it to add several.
#1 Best Overall
- BUILT FOR COLLEGE. AND BEYOND — MacBook Air with the M5 chip packs blazing speed and powerful AI capabilities into an incredibly portable design. And with up to 18 hours of battery life,* this thin and light powerhouse is ready to take on almost any major, just about anywhere.
- TEAR THROUGH TOUGH ASSIGNMENTS — With its faster CPU and unified memory, the M5 chip delivers even more performance and fluidity across apps, making multitasking and creative workflows smooth and responsive. A powerful Neural Engine and next-generation GPU with Neural Accelerators give you a powerful platform for AI.
- MAKE QUICK WORK OF YOUR TO-DO LIST — Apple Intelligence helps you write, express yourself, and get things done effortlessly — whether it’s for school or everyday life. With groundbreaking privacy protections, it gives you peace of mind that no one else can access your data — not even Apple.*
- UP TO 18 HOURS OF BATTERY LIFE — MacBook Air delivers incredible battery life with amazing performance, so you can power through a full day of classes without worrying about plugging in.
- A BRILLIANT 13.6-INCH DISPLAY* — The gorgeous Liquid Retina display on MacBook Air supports 1 billion colors, making photos and videos pop with rich contrast and sharp detail, and text appears supercrisp. So everything — from class presentations to movies to games — looks truly stunning.
Insert within the table
- Move the pointer over the number of the row or letter of the column where you want to insert.
- Click the arrow that appears.
- Choose the relevant command: Add Row Above or Add Row Below, or Add Column Before or Add Column After.
To insert several rows or columns at once, first select the same number of existing rows or columns as the number you want to add. Open the label arrow menu and choose Add Rows Above or Add Rows Below, or Add Columns Before or Add Columns After.
Add header or footer rows and columns
Adding headers or footers can convert existing table rows or columns into header or footer areas. Numbers supports up to five header rows, five header columns, and five footer rows. You can also freeze headers so they remain visible while scrolling. See Apple’s instructions for adding and removing rows and columns.
Rank #2
- AN AMAZING MAC AT A SURPRISING PRICE — With an incredibly portable and durable aluminum design, up to 16 hours of battery life,* and the A18 Pro chip, MacBook Neo is ready to go wherever school takes you.
- FOUR STUNNING COLORS. ONE DURABLE DESIGN — Choose from four beautiful colors — Silver, Blush, Citrus, or Indigo — each with a color-coordinated keyboard. And MacBook Neo is made with a durable recycled aluminum enclosure that helps it reach 60 percent recycled content by weight — the most ever in any Apple product.*
- FLY THROUGH EVERYDAY ASSIGNMENTS — Whether you’re cramming for finals, using Apple Intelligence* to summarize class notes, creating presentations, or even playing the latest Apple Arcade game,* MacBook Neo delivers the performance and AI capabilities you need to get things done.
- UP TO 16 HOURS OF BATTERY LIFE — MacBook Neo delivers all day battery life, so you can power through from early morning classes to late night study sessions without worrying about plugging in.
- A VIBRANT 13-INCH DISPLAY* — The gorgeous Liquid Retina display on MacBook Neo supports 1 billion colors, so photos and videos pop and text is crisp for easy reading.
How do I delete a row or column?
Delete an interior row or column
- Move the pointer over its row number or column letter, then click the arrow.
- Choose Delete Row or Delete Column.
For a nonadjacent selection, Command-click the relevant labels, open the arrow menu, and choose Delete Selected Rows or Delete Selected Columns.
Remove rows or columns at a table edge
The edge controls can remove rows or columns when the cells being removed are empty. To remove populated rows or columns at the edge, hold Option while dragging the combined Add or Remove Rows and Columns control. Check which cells the operation will remove before dragging: deleting a row or column removes its contents from the table.
Rank #3
- BUILT FOR COLLEGE. AND BEYOND — MacBook Air with the M5 chip packs blazing speed and powerful AI capabilities into an incredibly portable design. And with up to 18 hours of battery life,* this thin and light powerhouse is ready to take on almost any major, just about anywhere.
- TEAR THROUGH TOUGH ASSIGNMENTS — With its faster CPU and unified memory, the M5 chip delivers even more performance and fluidity across apps, making multitasking and creative workflows smooth and responsive. A powerful Neural Engine and next-generation GPU with Neural Accelerators give you a powerful platform for AI.
- MAKE QUICK WORK OF YOUR TO-DO LIST — Apple Intelligence helps you write, express yourself, and get things done effortlessly — whether it’s for school or everyday life. With groundbreaking privacy protections, it gives you peace of mind that no one else can access your data — not even Apple.*
- UP TO 18 HOURS OF BATTERY LIFE — MacBook Air delivers incredible battery life with amazing performance, so you can power through a full day of classes without worrying about plugging in.
- A BRILLIANT 13.6-INCH DISPLAY* — The gorgeous Liquid Retina display on MacBook Air supports 1 billion colors, making photos and videos pop with rich contrast and sharp detail, and text appears supercrisp. So everything — from class presentations to movies to games — looks truly stunning.
How do I hide or unhide rows and columns?
Hide selected items
- Select the rows or columns using their labels.
- Move the pointer over a selected row number or column letter and click its down arrow.
- Choose Hide Selected Rows or Hide Selected Columns.
A gray bar indicates the hidden area. Hiding changes visibility rather than deleting the rows or columns, so their data remains in the table and can still be used by formulas.
Unhide items
To reveal a hidden range, select an adjacent row or column, open its arrow menu, and choose the applicable Unhide option. To reveal every hidden row or column in the table, use the menu bar: Table > Unhide All Rows or Table > Unhide All Columns.
Rank #4
- AN AMAZING MAC AT A SURPRISING PRICE — With an incredibly portable and durable aluminum design, up to 16 hours of battery life,* and the A18 Pro chip, MacBook Neo is ready to go wherever school takes you.
- FOUR STUNNING COLORS. ONE DURABLE DESIGN — Choose from four beautiful colors — Silver, Blush, Citrus, or Indigo — each with a color-coordinated keyboard. And MacBook Neo is made with a durable recycled aluminum enclosure that helps it reach 60 percent recycled content by weight — the most ever in any Apple product.*
- FLY THROUGH EVERYDAY ASSIGNMENTS — Whether you’re cramming for finals, using Apple Intelligence* to summarize class notes, creating presentations, or even playing the latest Apple Arcade game,* MacBook Neo delivers the performance and AI capabilities you need to get things done.
- UP TO 16 HOURS OF BATTERY LIFE — MacBook Neo delivers all day battery life, so you can power through from early morning classes to late night study sessions without worrying about plugging in.
- A VIBRANT 13-INCH DISPLAY* — The gorgeous Liquid Retina display on MacBook Neo supports 1 billion colors, so photos and videos pop and text is crisp for easy reading.
Numbers does not let you hide rows or columns in a pivot table; Apple recommends using filters to limit the visible pivot-table data. Merged cells can also prevent particular rows or columns from being hidden. Apple documents these limits in its hide and show rows and columns guide.
Free tools Windows power users keep installed
One-click scans. No signup required.
How do I move a row or column?
Reorder rows
- Select the row or rows by their numbers.
- Click and hold one of the selected row numbers until the selection appears to lift off the table.
- Drag the selection above or below the destination row, then release.
Reorder columns
- Select the column or columns by their letters.
- Click and hold one of the selected column letters until the selection appears to lift off the table.
- Drag the selection to the left or right of the destination column, then release.
Moving rows between a header or footer area and the table body can change their formatting. Dragging rows or columns outside the existing table creates a new table. Apple’s row and column rearranging instructions describe the drag operation.
Move versus transpose: what is the difference?
Moving selected rows or columns changes their order within a table. Transposing is a separate whole-table operation that swaps rows and columns; it is not the way to reposition one selected row or column. Apple’s transpose instructions note that the command is unavailable when the table supplies a pivot table or the spreadsheet is shared. In some circumstances, transposing can discard sort or filter rules or unlink a form.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
