How to Unhide in Excel

If you’re an Excel user, there’s a good chance that you may have hidden a row, column, or worksheet at some point in your work. Hiding these elements can be a useful way to focus on the data you need to see. But what if you need to bring these hidden parts back? Fortunately, Excel provides an easy way to unhide rows, columns, and worksheets. In this post, we’ll show you how to quickly and efficiently unhide in Excel, so you can get back to working on your spreadsheet in no time.

Unhiding Rows in Excel

Rows can be hidden in Excel to make data easier to read or to protect sensitive information. To unhide rows, follow these simple steps:

1. Select the rows above and below the hidden row by clicking on the row number.
2. Right-click and select “Unhide.”
3. The row should now be visible.

Unhiding Columns in Excel

Columns can also be hidden in Excel for similar reasons. To unhide columns, follow these steps:

1. Select the columns to the left and right of the hidden column by clicking on the column letter.
2. Right-click and select “Unhide.”
3. The column should now be visible.

Unhiding Worksheets in Excel

If an entire worksheet has been hidden, it can be unhidden by following these steps:

1. Right-click on any worksheet tab.
2. Select “Unhide” from the menu.
3. Select the worksheet you want to unhide and click “OK.”
4. The worksheet should now be visible.

Using the Ribbon to Unhide in Excel

If you prefer using the Ribbon instead of right-clicking, follow these steps:

1. Select the rows, columns, or worksheet you want to unhide.
2. Go to the “Home” tab on the Ribbon.
3. In the “Cells” group, click on the “Format” dropdown arrow.
4. Select “Hide & Unhide” and then choose “Unhide Rows,” “Unhide Columns,” or “Unhide Sheet.”
5. The selected rows, columns, or worksheet should now be visible.

Unhiding Cells in Excel

If a cell has been hidden, it can be unhidden by following these steps:

1. Select the cells around the hidden cell.
2. Right-click and select “Format Cells.”
3. Go to the “Protection” tab and uncheck the “Hidden” checkbox.
4. Click “OK.”
5. The hidden cell should now be visible.

Unhiding Objects in Excel

If an object, such as a chart or image, has been hidden, it can be unhidden by following these steps:

1. Select the worksheet where the object is located.
2. Go to the “Home” tab on the Ribbon.
3. In the “Editing” group, click on the “Find & Select” dropdown arrow.
4. Select “Go To Special.”
5. Select “Objects” and click “OK.”
6. The hidden object should now be selected.
7. Right-click and select “Format Object.”
8. Go to the “Properties” tab and uncheck the “Hidden” checkbox.
9. Click “OK.”
10. The hidden object should now be visible.

Using Keyboard Shortcuts to Unhide in Excel

If you’re a fan of using keyboard shortcuts, you can quickly unhide rows, columns, and worksheets in Excel using the following:

• Rows: Ctrl + Shift + 9
• Columns: Ctrl + Shift + 0 (zero)
• Worksheets: Ctrl + Shift + S

Keep in mind that keyboard shortcuts may vary depending on your version of Excel.

Unhiding in Excel is a quick and easy process once you know the steps. Whether you’re unhiding rows, columns, worksheets, or objects, Excel provides several methods to make them visible again. By following the steps outlined in this article, you can confidently unhide any element in your Excel spreadsheet in no time.

FAQ

Here are some frequently asked questions related to unhiding in Excel:

Can I unhide multiple rows or columns at once?

Yes, you can unhide multiple rows or columns at once by selecting the rows or columns adjacent to the hidden ones, right-clicking, and selecting “Unhide.”

What if I can’t find the worksheet I want to unhide?

You may need to scroll to the left or right of your worksheet tabs to find the hidden worksheet. If you still can’t locate it, try right-clicking on any worksheet tab and selecting “Unhide.”

What if the “Unhide” option is grayed out?

This usually means that there are no hidden rows, columns, or sheets to unhide. Make sure you have selected the correct rows, columns, or sheet before right-clicking to check if the “Unhide” option is available.

Can I unhide cells with a formula in them?

Yes, you can unhide cells with formulas in them. Follow the steps outlined in the section above, and the formula will remain intact after unhiding.

How do I hide rows, columns, and worksheets in Excel?

To hide rows, select the rows you want to hide, right-click, and select “Hide.” To hide columns or worksheets, follow similar steps. Alternatively, you can use the Ribbon to hide rows, columns, or worksheets. Just select the row, column, or sheet and click on the “Format” dropdown in the “Cells” group, then select “Hide & Unhide” and choose “Hide Rows,” “Hide Columns,” or “Hide Sheet.”