How to Hide Columns and Rows in Numbers on iPhone

To hide a column or row in Numbers on iPhone, tap its lettered column header or numbered row header, then choose Hide Columns or Hide Rows from the selection menu. Hiding only removes it from view; it does not delete the cells or their contents.

Hide a column or row step by step

Open the spreadsheet in the Numbers app and go to the sheet containing the table. In Numbers, rows and columns belong to a table, so first identify the table and its header. A column is marked by a letter at the top, while a row is marked by a number along the left side. Tap the header itself, not a cell inside the table: tapping a cell selects that cell, whereas tapping its header selects the whole row or column.

Tap the letter above the column you want to hide, or the number beside the row.
When the header is selected and the selection menu appears, choose Hide Columns or Hide Rows, as appropriate. If the menu is compact, use its navigation or more-options control to find the hide command.
Check the table. The selected row or column should disappear, and the remaining content should shift together rather than leaving an empty gap.

For example, if a table has columns for Item, Quantity, Unit Price, and Notes, you could hide Unit Price while reviewing the other information. The table looks simpler, but the price values remain part of the spreadsheet. The command applies to the selected table’s row or column, not to every table on the sheet.

Hide more than one row or column

You can hide a group of neighboring rows or columns in one operation. Select the headers covering the range, then use the corresponding hide command. On iPhone, a practical way to extend a selection is to tap the first row or column header and drag the selection handles to include the adjoining headers. The exact handles and menu arrangement can vary with the current selection and screen size.

Suppose columns D, E, and F contain internal calculations that you do not need to see while checking the final totals. Select those three column headers together and choose Hide Columns. The visible columns remain in their original order; the hidden columns are simply skipped in the view. To hide separate, nonadjacent columns, repeat the operation for each separate selection if Numbers does not let you include them in one selection.

Take care to select the header range rather than dragging across cells. A cell-range selection is useful for editing data, but it is not the same as selecting whole columns or rows. If the wrong area becomes highlighted, tap a header again and confirm that the selection covers the intended row or column before choosing Hide.

Show hidden rows or columns again

Hiding is reversible. To restore a hidden section, select the visible row or column headers on either side of the gap, open the selection menu, and choose Unhide Rows or Unhide Columns. For instance, if column C is hidden between B and D, select the neighboring headers around the gap and look for the unhide command. If several consecutive columns are hidden, select the visible headers that border the group.

After unhiding, the data returns in its original position; it is not inserted as new data or copied elsewhere. If you cannot find the command, check that you selected headers rather than cells and that there really is a hidden row or column between the selected headers. At the edge of a table, there may not be a visible header on both sides of the hidden section, so inspect the boundary for a hidden-section indicator and use the available header selection or menu option. Menu labels and placement can differ slightly across Numbers versions.

What hiding changes—and what it does not

A hidden row or column remains part of the table. Its values, formulas, and formatting are not erased, and formulas elsewhere in the table can still refer to cells in hidden areas. If a total formula includes a hidden row, hiding that row does not by itself remove its value from the total. That is an important distinction: hide is a display choice, not a calculation instruction.

Hiding also is not a privacy or security measure. Someone with access to the spreadsheet may be able to unhide the information, and the hidden content remains in the file. Do not hide confidential figures as a substitute for removing them or controlling who can access the document. If you share a file, assume that recipients with editing access can inspect the underlying table.

Hiding may also affect what appears in a printed or exported view, depending on the output and its settings. Before sending a PDF or printing a sheet, review the print preview or exported result rather than assuming hidden information will be handled a particular way. The safe practice is to check the actual output and, for sensitive data, make a separate copy with the unwanted information removed.

Hide, filter, or freeze: which should you use?

These features solve different problems. Choose based on whether you want to change what is visible, which records appear, or what stays in place while scrolling.

Hide a row or column when you want to temporarily remove a known part of a table from view, such as a helper-calculation column or a completed set of rows.
Filter records when you want to show only rows that meet a condition, such as orders from one month or items marked “In stock.” A filter is better for changing which records are displayed based on their values. It is not the same as manually hiding a particular row.
Freeze headers when you want a heading row or column to remain visible as you scroll through a large table. Freezing does not remove data from view; it keeps selected headers in place for orientation.

For example, a long inventory table might benefit from a filter to show only low-stock items and frozen column headings so the labels stay visible. Hiding the Notes column is a separate choice if it is distracting during that review. Using the right feature makes it easier to return to the full table later and reduces confusion about why certain records are missing.

Common problems on iPhone

If the hide option does not appear, start by checking the selection. A tap in the body of the table usually selects a cell, not an entire row or column. Tap the letter or number at the table edge and wait for the selection controls or menu. If you are editing text in a cell, finish or cancel that edit, then select the header.

Also check whether the table is in a state that allows editing. A read-only file, a locked sheet or table, or an access level without editing permission can prevent changes. If the spreadsheet is shared, confirm that you have permission to edit. If a menu is partly off-screen or offers only a few commands, scroll or open its additional options rather than assuming the hide feature is unavailable.

Another common mix-up is mistaking a narrow column for a hidden one. A column may still exist but be too small to read. Select its header and adjust its width if you want to make it visible without changing the data. Conversely, if letters appear to skip—for example, B is followed by D—column C may be hidden. Look for the gap or hidden-section marker, then use the unhide command.

If the table is difficult to manipulate on a small screen, rotate the iPhone to landscape or zoom out temporarily. These changes can make adjacent headers easier to select, especially when the table has many narrow columns. Return to a comfortable zoom after the selection; changing the zoom does not itself hide or reveal any data.

Useful examples and workflow tips

For a budget table, you might hide a Notes column while comparing monthly totals, then unhide it when you need the explanation for a particular entry. In a project tracker, you could hide completed rows during a focused review, but a filter may be more efficient if you regularly switch between completed and active tasks. In a sales table, hiding a calculation column can simplify a presentation, while retaining it in the working file for formulas.

Before hiding a large block, note which headers or records it contains. This is especially helpful when a table has many similar columns or when another person will edit the document. A short label in an adjacent visible area, or a note in your workflow, can prevent confusion later. If you need a presentation-ready version that should not expose supporting information, duplicate the spreadsheet and remove the unwanted material from the copy rather than relying on hidden columns.

On a Mac or iPad, the same basic idea applies—select a row or column by its header and use the hide command—but the controls are arranged differently from the iPhone interface. On a Mac, you can use the larger table and menus; on iPhone, the selection menu is contextual and designed for touch. If you switch devices, look for the row or column header and the matching Hide or Unhide command instead of expecting identical button placement.

Frequently Asked Questions

Does hiding a column in Numbers delete its data?
No. Hiding removes the column from the current view, but the cells, values, and formulas remain in the table. Use a deletion command only if you intend to remove the column and its contents.

Will formulas still include a hidden row?
Usually, yes. Hiding is not the same as filtering or deleting, so formulas that refer to cells in the row can continue to use those values. Check the formula and the result if you need a total that excludes particular records.

How do I unhide a column in Numbers on iPhone?
Select the visible column headers around the hidden column, open the selection menu, and choose Unhide Columns. If the hidden column is at the edge of the table, look for the hidden-section indicator and select the available adjacent header.

Can I hide several columns at once?
Yes. Select a range of adjacent column headers and choose Hide Columns. For nonadjacent columns, you may need to hide each selection separately.

Can hiding a row protect private information?
No. Hidden content remains in the spreadsheet and can be revealed by someone who can edit or inspect it. Remove sensitive content from a separate sharing copy and manage access to the original file.

Why can’t I see the Hide option?
You may have selected a cell rather than its row or column header, be editing the table, or lack permission to change the file. Tap the letter or number at the table edge, confirm the whole row or column is selected, and check that the document is editable.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.