To do: Select a cell that you want to hide its row or columns, then use the following keyboard shortcut keys.Ĭtrl + Shift + (: Unhide the hidden rows within the selection.Ĭtrl + Shift + ): Unhide the hidden columns within the selection. How to hide or unhide rows or columns using shortcut key Step 3: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns. Or press Ctrl+A to select all cells on a worksheet. Option 2: Show all hidden rows and columns at the same time. Select row (s)/column (s) on both sides of hidden row (s)/column (s) 2. Now you should be able to see column A in your Excel spreadsheet. Select Cells > Format > Hide & Unhide > Unhide Columns. Select the Home tab from the toolbar at the top of the screen. When the GoTo window appears, enter A1 in the Reference field and click on the OK button. When you find there is a row or column hidden, you can simply drag the gridline to show it. MS Excel 2010 / How to unhide selected rows/columns 1. How do I unhide column A in Excel MS Excel 2010: Unhide column A. Option 1: Unhide a row or column by dragging the gridline. Option 2: Go to the Home tab, click Format, point to Hide & Unhide, then click Hide Rows or Hide Columns. Option 1: Right-click and select Hide row or Hide column from the menu that appears, To hide rows or columns in Excel worksheet, select the rows or columns that you want to hide. In this guide, you will learn several ways to show or hide a row or column, and display all hidden rows and columns at the same time. This is a quick guide on how to hide a row or column in Excel. How to Hide or Unhide Rows or Columns in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |