To unhide all of the cells in a worksheet:
- Click the Select All button, in the upper-left corner of the worksheet or press Ctrl + A.
- Click the Home tab > Format (in the Cells group) > Hide & Unhide > Unhide Rows or Unhide Columns.
- All cells are now visible.
Contents
Why can’t I unhide 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 I unhide all columns in Excel?
Here are the steps to unhide all columns at one go:
- Click on the small triangle at the top left of the worksheet area. This will select all the cells in the worksheet.
- Right-click anywhere in the worksheet area.
- Click on Unhide.
How do I unhide all?
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. Note that you need to select the identifier—you can’t just click anywhere and select Unhide using this particular method.
Why can I see rows 1 and 2 Excel?
Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Rows. Row 1 should now be visible in the spreadsheet.Try hiding rows 1-3 (even if they were hidden) and then try unhiding them again.
Can’t unhide a column in Excel?
To unhide column A, right-click the column B header or label and pick Unhide Columns. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. Tip: If you don’t see Unhide Columns or Unhide Rows, make sure you’re right-clicking inside the column or row label.
What is the Excel shortcut for unhide?
There are several dedicated keyboard shortcuts to hide and unhide rows and columns.
- Ctrl+9 to Hide Rows.
- Ctrl+0 (zero) to Hide Columns.
- Ctrl+Shift+( to Unhide Rows.
- Ctrl+Shift+) to Unhide Columns – If this doesn’t work for you try Alt,O,C,U (old Excel 2003 shortcut that still works).
Can you unhide all sheets in Excel at once?
Unfortunately, there is no in-built functionality in Excel to quickly unhide all the hidden worksheets (or a way to select more than one worksheet and unhide it). As of now, you need to use the unhide dialog box where you can only select one worksheet to unhide.
How do I unhide rows at the top of an Excel spreadsheet?
If you’re trying to unhide rows at the top of the worksheet, click on the first visible row, and then move your mouse up to the top of the screen. Alternatively, you can select a row or rows, and then press Ctrl-9. To unhide rows, press Ctrl-Shift-9.
How do I unhide all rows and columns in Excel?
To unhide all rows and columns, select the whole sheet as explained above, and then press Ctrl + Shift + 9 to show hidden rows and Ctrl + Shift + 0 to show hidden columns.
When you want to reveal cells that may reside in hidden rows or columns, it can be difficult to locate them.
Locate hidden cells
- Press F5 > Special.
- Press Ctrl+G > Special.
- Or on the Home tab, in the Editing group, click Find & Select>Go To Special.
What does Ctrl O do?
Alternatively referred to as Control+O and C-o, Ctrl+O is a keyboard shortcut most often used to open a URL, document, image, or other file types.On Apple computers, the keyboard shortcut to open is Command + O .
What does Ctrl 9 do in Excel?
Press Ctrl + 9 to hide selected rows, Ctrl + Shift + 9 to unhide any hidden rows, Ctrl + 0 (zero) to hide selected columns, and Ctrl + Shift + 0 to unhide any hidden columns.
How do you unfreeze a column in Excel?
To unfreeze panes:
To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.