Just as you can quickly hide and unhide columns, you can hide or reveal hidden rows in your Excel spreadsheet as well. Show
In addition to freezing rows, you may find it helpful to conceal rows you are no longer using without permanently deleting the data from your spreadsheet. To later reveal the hidden cells, you can right-click to unhide individual rows. You can also navigate to the "Format" option to unhide all hidden rows. This feature is especially helpful if you've hidden multiple rows throughout a large spreadsheet. Here's how to do both. Check out the products mentioned in this article:Microsoft Office (From $139.99 at Best Buy)MacBook Pro (From $1,299.99 at Best Buy)Microsoft Surface Pro X (From $999 at Best Buy)How to hide individual rows in Excel1. Open Excel. 2. Select the row(s) you wish to hide. Select an entire row by clicking on its number on the left hand side of the spreadsheet. Select multiple rows by clicking on the row number, holding the "Shift" key on your Mac or PC keyboard, and selecting another. 3. Right-click anywhere in the selected row. 4. Click "Hide." Right-click to hide rows.Marissa Perino/Business InsiderHow to unhide individual rows in Excel1. Highlight the row on either side of the row you wish to unhide. 2. Right-click anywhere within these selected rows. 3. Click "Unhide." 4. You can also manually click or drag to expand a hidden row. Hidden rows are indicated by a thicker border line. Move your cursor over this line until it turns into a double bar with arrows. Double click to reveal or click and drag to manually expand the hidden row or rows. (If you've hidden multiple rows, you may have to do this multiple times.) How to unhide all rows in Excel1. To unhide all hidden rows in Excel, navigate to the "Home" tab. 2. Click "Format," which is located towards the right hand side of the toolbar. 3. Navigate to the "Visibility" section. You'll find options to hide and unhide both rows and columns. 4. Hover over "Hide & Unhide." 5. Select "Unhide Rows" from the list. This will reveal all hidden rows, a feature especially helpful if you've hidden multiple rows throughout a large spreadsheet. Related coverage from How To Do Everything: Tech:
Marissa Perino Marissa Perino is a former editorial intern covering executive lifestyle. She previously worked at Cold Lips in London and Creative Nonfiction in Pittsburgh. She studied journalism and communications at the University of Pittsburgh, along with creative writing. Find her on Twitter: @mlperino. Over the course of a long night, you prepared your spreadsheet. However, when you looked at it the next morning, you find that you cannot see several columns. Do not worry -- Excel did not spontaneously erase data from your spreadsheet. It just means that you accidentally used the "Hide" feature on the missing columns. Fortunately, you can use the "Unhide" command to make individual or all hidden columns visible again. Individual Columns
All Hidden Rows
|