WebOct 22, 2024 · Use Shortcut Keys to Select Rows. Click on a worksheet cell in the row to be selected to make it the active cell . Press and hold the Shift key on the keyboard. Press and release the Spacebar key on the keyboard. Shift+Spacebar. Release the Shift key. All cells in the selected row are highlighted; including the row header . WebNov 17, 2024 · Press Ctrl+Shift+9, right-click a cell, and choose "Unhide," or select Format > Hide & Unhide > Unhide Rows from the ribbon at the top to unhide all rows. Unhiding all …
How To Unhide All Rows in Excel (With 3 Methods)
WebSometimes you may want to unhide just a single row or column. There are two ways to do so: 1. Press Ctrl-G to display the Go To window, type in the address of a cell in the row or column that you wish to unhide, and then … WebOn the Home tab, in the Editing group, click Find & Select, and then click Go To. In the Reference box, type A1, and then click OK. On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, click … ile o reflets troo
Excel - How To Unhide A Specific Row - YouTube
WebJun 15, 2024 · Tried several things, including the following: Select whole worksheet in upper left corner. Selected the Cells icon on the Home page tool bar. Selected Visibility / Hide & Unhide / Unhide Rows. It didn’t work. Selected the row before and after the ones I wanted to unhide. Selected the Cells icon again from the Home tab. WebNov 1, 2024 · 3 Answers Sorted by: 1 Hiding Rows Based upon Value in F16 Block1 = rows 16 to 27 Block2 = rows 28 to 39 Block3 = rows 40 to 51 if F16 = "A" - show block1, hide block2, hide block3 if F16 = "B" - hide block1, show block2, hide block3 if F16 = "C" - hide block1, hide block2, show block3 WebSince you can’t select the specific hidden rows, you need to drag “over” them with your cursor while holding down the left mouse button. 2. Right-click any of the selected rows. … ileostomy and marshmallows