How to Hide and Unhide Rows and Columns - Techxio.com

The Educational & IT Support Site

Breaking

Home Top Ad

Post Top Ad

24 July 2022

How to Hide and Unhide Rows and Columns

How to Hide and unhide Rows and Columns ? 

Sometimes user may want to hide entire rows or columns in an Excel worksheet. It may be some cells, rows or columns that may contain some additional data that is referred in other cells but need user may not want it to show.

How to hide rows or columns?

1. Select the Rows or Columns that you want to hide.

2. On the Home tab, in the Cells group, click Format.

3. Under Visibility, point to Hide & Unhide, and then click Hide Rows or Hide Columns.

How to Hide and unhide Rows and Columns


or

You can also select on or more rows or columns and right click and select Hide option from popup menu.

No comments:

Post a Comment

Post Bottom Ad

Pages