Office

Show or hide rows or columns in Excel 2016

Hide rows and columns

  1. Select the row or column that you want to hide.
  2. On the Home tab, click the Format menu.
  3. Point to Hide & Unhide, and then click either Hide Rows or Hide Columns.

Show hidden rows and columns

  1. Do one of the following:
    To Do this
    Display hidden rows Select cells in the row above and in the row under the hidden rows.
    Display hidden columns Select cells in the column to the left and in the column to the right of the hidden columns.
    Display all hidden columns or rows Select all cells on the sheet by clicking the Select All triangle at the upper-left corner of the sheet grid.

    Triangle in upper left corner, used to select all rows and columns

  2. On the Home tab, click the Format menu.

    On the Home tab, Format is highlighted

  3. Point to Hide & Unhide, and then click either Unhide Rows or Unhide Columns.

    Note: If the first row or column of a sheet is hidden, on the Edit menu, click Find, and then click Go To. In the Reference box, type A1, and then click OK. On the Home tab, click the Format menu. Point to Hide & Unhide, and then click either Unhide Rows or Unhide Columns.

(Visited 27 times, 1 visits today)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.