![]() Next, click on the Hide & Unhide After that, click on Unhide Rows button.After you have selected all rows, go to the Cells group from the Home tab.First, click on the Select All button to select all rows from the worksheet.Now, the most used method to unhide all hidden rows is using the ribbon. We will unhide all the rows using the following methods. We will use this dataset in the following sections: It will definitely develop your Excel knowledge. I recommend you learn and apply all the methods to your spreadsheet. In the following sections, I will provide you with four easy ways to unhide all hidden rows in Excel. To choose the whole worksheet again, press Ctrl+A again. But, if the cursor is in one of the adjacent cells with data, it will only select the dataset. If you point the cursor in a blank cell, this shortcut will select the whole spreadsheet. Click the Select All button (the little triangle at the intersection of rows and columns)Ī note to remember is, in Microsoft Excel, this shortcut acts differently in distinct circumstances.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |