![]() ![]() Then press Ctrl + Shift + 9 keyboard combination to unhide all rows, or press Ctrl + Shift + 0 to show all hidden columns. If you want to unhide all rows or columns on a sheet, make sure the whole worksheet is selected. Part 3: Quickly Unhide All Hidden Rows or Columns Right-click the selected column headers and pick Unhide. To unhide a column, select the columns before and after the hidden columns. ![]() Then, right-click on the selection and click Unhide from the popup menu. Since row 3 is hidden, we want to select rows 2 to 4. To unhide a row, just select the row above and the row below the hidden row. ![]() Part 2: Unhide a Whole Row or Column in Excel 2016 But you’ll see double lines at column or row headers, which indicates a column or row is hidden.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |