WebAug 14, 2024 · Beginning rows hidden Enter 1:10 into the Name Box, where 10 is the first visible row. Right-click "10" (first visible row number) and click Unhide. 2. Rows in between hidden Enter 12:23 into the Name Box, where 12 and 23 are the two closest visible rows. Or select row numbers "12" and "23" by dragging the mouse cursor. WebMar 28, 2024 · To unhide rows, you need to first select the rows that are directly above and below the hidden rows. Click on the row number above the hidden rows and drag your cursor down to the row number below the hidden rows, highlighting both visible rows and the gap where the hidden rows are located. 4. Access the ‘Format’ option.
How to Unhide All Rows in Excel: Step-by-Step (+ Columns) - Sprea…
WebOr, every other row. You can quickly unhide all rows and columns by using control + A to select the entire worksheet, and then using Control + Shift + 0, or Control + Shift + 9, or both. Also, remember that you can use Select Special to make more complicated selections before you hide. For example, to hide all rows that contain the divide by ... WebApr 12, 2024 · The instructions you were given pertain to Excel for Windows, but you don't need all that rigamarole in the first place, even on a Windows PC :-). While viewing the sheet go to Edit> Select All [or use the Command+A keyboard shortcut] then go to Format> Row - Unhide. Hi Bob, Thank you for your response. It's the next step that I am having ... grevenrath grefrath
How to Unhide Columns in Excel: 4 Easy Step-by-Step Methods
WebNov 19, 2024 · How to unhide individual rows in Excel. 1. Highlight the row on either side of the row you wish to unhide. 2. Right-click anywhere within these selected rows. 3. Click … WebJun 24, 2024 · Follow these steps to unhide an individual row in Excel: Highlight a row on either side of the row that you want to unhide, such as Row 10 or Row 12 if you want to … WebSelect the rows that you want to unhide by clicking on the row numbers in the left-hand column or by dragging your mouse acros them. 2. Right-click on one of the selected rows and select “Unhide ... greven psychotherapeut