On the Home tab, in the Cells group, click Format. Select the column (or a cell in the column) you want to hide. In the Format submenu, click Hide & Unhide.
To unhide rows again, make a selection that spans hidden rows, and use Control Shift 9. Again, youll see a visual indication in row numbers to indicate that rows are hidden. To unhide all rows, click the box to the left of the A and above the 1 on the.To hide rows, use Control + 9. Unhide Rows by Clicking the Up/Down Caret IconUnhiding rows Select the row headings above and below the hidden row(s). Select the rows (or cells in the rows) above and below the hidden row.
The hidden rows are designated by the caret icons above and below the neighboring row numbers. However, you may encounter more complicated use cases where you want to unhide multiple row groups or all the rows on a page.In the following example, Google Sheets is hiding nonconsecutive rows in two groups.We can’t see the information in rows 4, 5, 8, and 9. You can tell those rows are missing because the numbering jumps from 3 to 7 and there are up/down caret icons next to the range.If you left-click on either of the caret icons, Google Sheets will show the data in the hidden rows again.The below image shows how Google Sheets will automatically select the data in the formerly hidden row range upon reveal.Clicking the icons is straight-forward for showing individually hidden row groupings. You May Also Like the Following Tutorials:Unhide Rows by Clicking the Up/Down Caret IconGoogle Sheets displays upward and downward-facing caret icons on the rows above and below hidden row ranges.The following spreadsheet is hiding rows 4 through 6. Manually select the range by left-clicking a row above the first hidden group. Set Groups for Fast Unhide/Hide of RowsUnhide Selection Range Highlight the desired range of rows you want to show.
Then hold the “shift” key and select a row below the hidden group range. Manually select the range by left-clicking a row above the first hidden group. Highlight the desired range of rows you want to show.
0 kommentar(er)
