Navigate to the Home tab > Cells group, and press the Format button.If you like going with the ribbon, you follow this: With the rows chosen, continue with a method that is listed below. To pick non-contiguous rows, press the heading of the 1st row and keep down the Ctrl key while pressing the headings of different rows that you need to select.Or pick the 1st row and hold down the Shift key while picking the last row. To pick many contiguous rows, drag over the row headings using the mouse.Nevertheless, you start with picking the rows you would want to hide: How To Unhide All Rows In Excel Hide Rows in ExcelĪs is the case with almost all general tasks in Excel, there is numerous way to hide rows like by doing the ribbon button, right-click menu, and keyboard shortcut. These words will guide you with both choices. On the other side, when renewing your own sheets or exploring received workbooks, you would surely need to unhide all rows and columns to see all information and understand the dependencies. This method is often used to conceal sensible information or formulas, but you may also want to hide fresh or unimportant areas to hold your users focused on related information. If you need to stop users from walking into parts of a worksheet you do not need them to see, then guard such rows from their appearance. Luckily, the software of Microsoft Excel does it simply to do this.
#How to unhide all sheets in excel at once how to#
Queries to know how to unhide rows in Excel? If you are ongoing with a data-heavy spreadsheet, seldom it is important to hide or unhide rows and columns to entirely understand the data you require to analyze, instead of removing the row.