MS-Excel / General Formatting

Hide and Unhide Columns and Rows

  1. Select the column or row headings you want to hide. If you want to unhide rows or columns, select the row or columns both before and after the hidden rows or columns.
  2. Choose Home> Cells> Format> Hide and Unhide. A menu of options appears. You cannot hide selected cells; only entire columns or rows. For example we choose rows to hide.

    Choose Row to Hide

  3. Make a selection. In Figure, notice that rows 6 and 7 are hidden and seem to have disappeared.

    Row 6 and 7 are Hidden
[Previous] [Contents] [Next]

In this tutorial:

  1. Protecting Excel Data
  2. Quickly Hide an Open Workbook
  3. Make a File Read-Only
  4. Mark a Workbook as Final
  5. Inspecting a Workbook
  6. Hide and Unhide Columns and Rows
  7. Excel Unlock Cells
  8. Protect Worksheets
  9. Excel Restrict User Data Entry
  10. Excel Assign a File Password
  11. Excel Hide Cell Formulas
  12. Protecting a workbook's structure
  13. Using a digital signature in Excel
  14. Signing a Workbook