Popular tips

How do I unhide all columns in Excel?

How do I unhide all columns in Excel?

How to unhide columns in Excel:

  1. Click on the small green triangle in the top left corner of your spreadsheet. This will select the entire spreadsheet.
  2. Now right-click anywhere in the entire selection and choose the Unhide option from the menu.
  3. You should now be able to see all of your columns.

How do I unhide all rows and columns?

Press Ctrl + Shift + 9 to unhide all rows or Ctrl + Shift + 0 (zero) to unhide all columns. If this doesn’t work, then right-click on a row or column identifier and select Unhide.

Why can’t I unhide all rows in Excel?

If you select all the rows and click ‘unhide’ and they do not show up, then they are filtered and not hidden. Click the Sort & Filter button on the Home tab of the ribbon and then click ‘clear’. On the Home tab, click on the Format icon Choose Hide & Unhide from the dropdown menu then select Unhide Rows.

How do you unhide multiple rows in Excel?

If you notice that several rows are missing, you can unhide all of the rows by doing the following:

  1. Hold down Ctrl (Windows) or ⌘ Command (Mac) while clicking the row number above the hidden rows and the row number below the hidden rows.
  2. Right-click one of the selected row numbers.
  3. Click Unhide in the drop-down menu.

How do you unlock hidden rows in Excel?

Fortunately, it’s just as easy. Highlight the rows on either side of the hidden row, and press Ctrl + Shift + 9. You’ll get your row back. You can also highlight those two rows, right-click, and select Unhide: Like the data in hidden cells, the contents of hidden rows are still seen by formulas.

How to delete all hidden rows or columns in Excel?


  • please specify the scope that you want to apply the operation from Look in drop down list.
  • please checked Columns.
  • Click OK.
  • How do you show all hidden columns in Excel?

    If you have an Excel table where multiple columns are hidden and want to show only some of them, follow the steps below. Select the columns to the left and right of the column you want to unhide. For example, to show hidden column B, select columns A and C. Go to the Home tab > Cells group, and click Format > Hide & Unhide > Unhide columns.

    Why does unhide not work in Excel?

    If you are having an issue with Excel’s unhide rows not working, you may discover that it is because the rows are not actually hidden. The most common cause for this is frozen panes.