How to Add, Remove, and Hide Rows or Columns in Excel

How to Show Hidden Rows or Columns in Excel

If you want to reshow rows or columns that you have hidden before, you can use the following ways:

1] Using the Format Menu

This method is the most common and easy way to show hidden rows or columns in Excel. Here are the steps:

1. Select any cell in the row or column adjacent to the hidden row or column. For example, if you want to show hidden row 5 again, select any cell in row 4 or 6. If you want to show hidden column C again, select any cell in column B or D.
2. Click the “Home” tab on the “Ribbon”, just like the previous method.
3. Click the “Format” button in the “Cells” group, just like the previous way.
4. Hover over the “Hide & Unhide” option, just like the previous method.
5. Select the “Unhide Rows” option to show hidden rows again, or the “Unhide Column” option to show hidden columns again. It will display the rows or columns again according to the cell position you selected earlier.
6. Repeat these steps to redisplay more than one row or column.

2] Using Right Click

This method is an alternative way that is also quite easy to show hidden rows or columns in Excel. Here are the steps:

1. Select any cell in the row or column adjacent to the hidden row or column, just like the previous way.
2. Right-click on the selected cell. This will open a context menu with several options.
3. Select the “Unhide” option. It will display the rows or columns again according to the cell position you selected earlier.
4. Repeat these steps to redisplay more than one row or column.

3] Using Width or Height Adjustments

This method is the most manual and flexible way to show hidden rows or columns in Excel because you can specify the width or height of the rows or columns you want to display exactly. Here are the steps:

1. Hover over the border between two-row numbers or two-letter columns adjacent to the hidden row numbers or column letters. For example, if you want to show hidden row 5 again, hover over the border between numbers 4 and 6 over any cell in rows 4 or 6. If you want to show hidden column C again, hover over the border between the letters B and D above any cell in column B or D.
2. The cursor will change to the shape of two arrows opposite each other, just like the previous way.
3. Drag the cursor towards the right or bottom until the width or height of the row or column becomes your best. It will display the row or column again according to the previous cell position. You can see the hidden row numbers or column letters are grayed out between contiguous row numbers or column letters.
4. Repeat these steps to redisplay more than one row or column.

Conclusion

By knowing how to add, delete, and hide rows or columns in Excel, you can make your Excel worksheet neater and more efficient. You can also manipulate data according to your needs, either to insert additional data, delete unnecessary data, or hide sensitive data.

There are several ways you can do these things, either by using menus, right-clicking, or keyboard shortcuts. You can also adjust the width or height of rows or columns by dragging the cursor. If you want to show back rows or columns that you have hidden before, you can use the same ways.

Hope this article will be helpful for those of you who want to learn more about how to add, delete, and hide rows or columns in Excel. Good luck!