![]() On the Home tab, in the Cells group, click Format.To select all cells on a worksheet, do one of the following: Click the Select All button.Related Question How do I unhide all columns in an Excel spreadsheet? Can't unhide all rows Excel? Select "Visibility," and then select "Hide & Unhide" and "Unhide Columns" to make all missing columns visible. Tip: If you don't see Unhide Columns or Unhide Rows, make sure you're right-clicking inside the column or row label. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. If you don't see the first column (column A) or row (row 1) in your worksheet, it might be hidden. ![]() Note that you need to select the identifier-you can't just click anywhere and select Unhide using this particular method. If this doesn't work, then right-click on a row or column identifier and select Unhide. Press Ctrl + Shift + 9 to unhide all rows or Ctrl + Shift + 0 (zero) to unhide all columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |