Question

You can unhide the collapsed rows in the sheet by using __________ detail command.​

Answer 1

Answer:

Explanation:

Once the entire sheet is selected, you can unhide all rows by doing one of the following: Press Ctrl + Shift + 9 (the fastest way). Select Unhide from the right-click menu (the easiest way that does not require remembering anything). On the Home tab, click Format > Unhide Rows (the traditional way).

Answer 2

Answer:

Anyway, you begin with selecting the rows you'd like to hide:

To select one row, click on its heading.

To select multiple contiguous rows, drag across the row headings using the mouse. Or select the first row and hold down the Shift key while selecting the last row.

To select non-contiguous rows, click the heading of the first row and hold down the Ctrl key while clicking the headings of other rows that you want to select.

With the rows selected, proceed with one of the following options.