Unhide Cells in Excel – 5 Easy Methods

Unhide Cells in Excel means you’ve probably hidden a row, column, or worksheet before to focus on important data. But what if you need to see those hidden parts again? Don’t worry—Excel makes it easy to unhide them. In this guide, we’ll show you how to quickly unhide cells in excel (unhide rows and columns) in excel so you can get back to working on your spreadsheet fast.

1. Unhide Cells in Excel Using Unhide Button

Sometimes rows are hidden in Excel to simplify the view or protect sensitive info. To unhide them, follow these easy steps:

  1. Click on the row numbers above and below the hidden row.
  2. Right-click and select “Unhide.”
19.1 unhide cells

3. The hidden row will now appear.

Excel VBA Master Tool Kit
 

2. Unhide Cells in Excel using Format Options

Here’s how you can unhide hidden rows or columns using the Format option:

  1. Highlight the cells around the hidden ones.
  2. Go to the Home tab and click Format in the Cells group.
  3. Under Visibility, choose Hide & Unhide.
  4. Select Unhide Rows or Unhide Columns to reveal the hidden cells.
19.3 unhide cells

This method works if the regular ‘Unhide’ button doesn’t!

19.4 unhide cells

3. Unhide Cells in Excel by Dragging

  • Double-clicking the right border of a hidden column can automatically adjust its width, but it might make the sheet too wide if many columns are hidden.
  • To avoid this, you can drag the column border instead.
  • Look for the double-line between two visible columns. This is where the hidden columns are.
  • Left-click on the right side of the double-line and drag it to the right until the hidden columns become visible.
19.5 unhide cells
Unhide Cells in Excel - 5 Easy Methods

4. Shortcut to Unhide Cells in Excel

The shortcut to unhide rows or columns in Excel is:
  • Unhide Rows: Select the hidden rows and press Ctrl + Shift + 9.
  • Unhide Columns: Select the hidden columns and press Ctrl + Shift + 0.
  • For Hidden Worksheet :  Ctrl + Shift + S
Unhide Cells in Excel - 5 Easy Methods

5. Unhide Cells in Excel Using Name Box

To unhide column A using the Name Box in Excel, follow these steps:

  1. Click on the Name Box (located to the left of the formula bar).
  2. Type A1 and press Enter.
  3. Green line indicates that column A selected (even though it’s hidden), go to the Home tab.
  4. Click on Format in the Cells group.
  5. Under Visibility, choose Unhide Columns.
19.9 unhide cells

This will unhide column A.

Unhide Cells in Excel - 5 Easy Methods

Conclusion

Unhiding cells in Excel is an easy way to make sure you can see and use all your data. Whether rows or columns are hidden, Excel provides simple tools to unhide them, By learning these steps, you can quickly find and manage hidden data, making it easier to work with your spreadsheet and ensuring nothing is missed.

FAQs

  1. How to Hide Cells in Excel?
  • Select the cell(s) you want to hide.
  • Go to the Home tab > Cells group > Format > Format Cells.
  • In the Format Cells menu, under the Number tab, select Custom.
  • Type ;;; (three semicolons) and click OK.

2. How to Hide Gridlines in Excel?

  • Go to the Page Layout tab.
  • Uncheck the View box under Gridlines.

3. How to Hide Formulas in Excel?

  • Select the cells with formulas.
  • Go to Format Cells > Protection tab, check Hidden, and click OK.
  • Then, go to the Review tab > Protect Sheet. Ensure “Protect worksheet and contents of locked cells” is enabled, and click OK.

4. The first 7 rows of my Excel sheet are missing, and using the “unhide” option from the Format menu isn’t working. How can I fix this?

  • You need to unlock the cells first (using the format pop-up), then hide them again before trying to unhide them.

Hope you this article is helpful. Follow us to learn more .

Related articles:-

  1. How to Hide Sheet in Excel with or without VBA?

  2. How to Delete Blank Rows in Excel – 6 Easy Methods

  3. VBA Code to Find Last Column or Row of a Sheet

 

Similar Posts

Why use dollar sign ($) in Excel formulas – absolute and relative cell references
| |

Why use dollar sign ($) in Excel formulas – absolute and relative cell references

BySumit Shrimal

When creating a formula in Excel, many people get confused by the $ symbol in cell references. But it’s actually very simple. The dollar sign in an Excel cell reference tells Excel whether to keep the reference the same or allow it to change when you copy the formula to other cells. This guide will explain how it works and why it’s helpful.
Understanding Excel cell references is really important. Knowing the difference between absolute, relative, and mixed references will help you get the most out of Excel formulas and functions.

Leave a Reply

Your email address will not be published. Required fields are marked *

Excel VBA Master Tool Kit