Keyboard shortcuts You can also select one or more rows and then press Ctrl9. To view rows, press CtrlShift9. For columns, use Ctrl0 (that’s a zero) or CtrlShift0.
How to show rows in Excel 2010?
Question: How can I show a row that has been hidden in Microsoft Excel 2010? Answer: Select the line above and the line below the hidden line. Right-click and select View from the context menu. Now the hidden line should be visible.
How to show rows quickly?
How to show all rows in Excel
- Press Ctrl+Shift+9 (fastest way).
- Choose View from the context menu (the easiest way that doesn’t require memorization).
- On the Home tab, click Format > Show Rows (traditional method).
What is shortcut to show columns in Excel 2010?
You must select the hidden column before you can unhide it with CTRL+SHIFT+0. Probably the easiest way is to paste a cell into the name box (top left box that lists the cell’s notation) and then CTRL+SHIFT+0. 31
Why can’t I see all rows in Excel?
If you select all rows and click Unhide and they are not shown, they are filtered and not hidden. On the Home tab of the ribbon, click the Sort & Filter button, and then click Delete.
What is the shortcut to show rows in Excel?
Keyboard shortcuts You can also select one or more rows and then press Ctrl9. To view rows, press CtrlShift9. For columns, use Ctrl0 (that’s a zero) or CtrlShift0. 17
How to find hidden cells in Excel 2010?
Find hidden cells
- Press F5 > Special.
- Press Ctrl+G > Special.
- Or on the Home tab, in the Editing group, click Find & Select > Go To Special.
How to show first column in Excel 2010?
Select the Home tab from the toolbar at the top of the screen. Choose Cells > Format > Show and Hide > Show Columns. You should now be able to see column A in your Excel spreadsheet.
What is the shortcut to show columns in Excel?
Keyboard shortcuts You can also select one or more rows and then press Ctrl9. To view rows, press CtrlShift9. For columns, use Ctrl0 (that’s a zero) or CtrlShift0.