You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

hiding rows in Numbers

Hi, I want to hide some rows in numbers, but the menu item is dimmed, hence it is impossible. What can be the reason for this? There are no connected cells within these rows.


Any idea or hint?


Peter

MacBook Air

Posted on Aug 4, 2020 4:47 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 4, 2020 7:27 AM

Peter, are you saying this doesn't work?


Hiding rows or columns is useful if, for example, you need to use their data for formulas, but you don’t want the data to be visible.

  1. Select the rows or columns you want to hide.
  2. Move the pointer over a row number or column letter, then click the down arrow that appears and choose Hide Selected Rows or Hide Selected Columns.
  3. A gray bar appears between the column letters or row numbers to show where columns and rows are hidden.
  4. Note: If the rows or columns you select contain merged cells, you may not be able to hide those rows or columns. For example, if you merge two cells in one row, you can hide the row that contains the merged cells, but you can’t hide columns that include the merged cells.

To show hidden rows or columns, select a row or column adjacent to the hidden ones. Move the pointer over the row number or column letter, click the down arrow, then choose an Unhide option.

To unhide all rows or columns, click the table, then choose Table > Unhide All Rows or Unhide All Columns (from the Table menu at the top of your screen).

4 replies
Question marked as Top-ranking reply

Aug 4, 2020 7:27 AM in response to Peter_MZ

Peter, are you saying this doesn't work?


Hiding rows or columns is useful if, for example, you need to use their data for formulas, but you don’t want the data to be visible.

  1. Select the rows or columns you want to hide.
  2. Move the pointer over a row number or column letter, then click the down arrow that appears and choose Hide Selected Rows or Hide Selected Columns.
  3. A gray bar appears between the column letters or row numbers to show where columns and rows are hidden.
  4. Note: If the rows or columns you select contain merged cells, you may not be able to hide those rows or columns. For example, if you merge two cells in one row, you can hide the row that contains the merged cells, but you can’t hide columns that include the merged cells.

To show hidden rows or columns, select a row or column adjacent to the hidden ones. Move the pointer over the row number or column letter, click the down arrow, then choose an Unhide option.

To unhide all rows or columns, click the table, then choose Table > Unhide All Rows or Unhide All Columns (from the Table menu at the top of your screen).

hiding rows in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.