Hello Visitor! Welcome to our website HariKnowledge here you’ll get answer of your question about Hide or Unhide Row and Columns in Excel Sheet.
To show or unhide rows or columns in Excel, follow these steps:
- Open your Excel spreadsheet.
- Select the entire range of rows or columns surrounding the hidden rows or columns. You can do this by clicking on the row or column headers. For example, to select all rows from 1 to 10, click and drag over the row numbers “1” to “10” on the left side of the sheet.
- Right-click on the selected rows or columns and choose “Unhide” from the context menu. If you don’t see the “Unhide” option, it means there are no hidden rows or columns in the selected range.
- The hidden rows or columns will now be visible again.
Alternatively, you can use the ribbon options to show or unhide rows or columns:
To unhide rows:
- Select the row above and below the hidden rows.
- Go to the “Home” tab in the Excel ribbon.
- In the “Cells” group, click on the “Format” button.
- From the drop-down menu, select “Hide & Unhide” and then choose “Unhide Rows.”
To unhide columns:
- Select the column to the left and right of the hidden columns.
- Go to the “Home” tab in the Excel ribbon.
- In the “Cells” group, click on the “Format” button.
- From the drop-down menu, select “Hide & Unhide” and then choose “Unhide Columns.”
Following these steps, you should be able to show or unhide rows or columns in Excel easily.
