➣Finally, the hidden rows are visible again. To Unhide rows, go to the Home tab > Cells section > select Format > then Hide & Unhide from the menu. ➣We’ll choose the rows we wish to unhide again in the same way we did before. Similar to the above dataset, we can also unhide rows from the Format feature in the ribbon. Read more: How to Hide and Unhide Rows in Excel ➣Simply move the mouse over the hidden rows headings and double-click until the mouse pointer becomes a split two-headed arrow. The beauty of this strategy is that it eliminates the necessity for selection. In many cases, the quickest way to reveal the hidden rows is by double-clicking. Read more: Shortcut to Unhide Rows in Excel The rows are then shown on the spreadsheet. ➣This makes the hidden rows unhide again. The Unhide option can be found by right-clicking on the mouse. It’s as simple as picking one row above and one row below the row or rows you want to see. ➣To begin, choose the rows that you want to reveal. Let’s go through the following steps to see how this feature works to unhide rows in excel. The way to find them is to look for a double line among the rows heading. Generally, It’s quite easy to spot the hidden rows in a spreadsheet. Show Hidden Rows Using Context Menu in Excel We will utilize this basic dataset which contains some item names and the complete sell information in the long stretch of January to March.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |