You are viewing the article How to Unhide Lines in Excel at Lassho.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 122,680 times.
This is an article that shows you how to unhide one or more lines in a Microsoft Excel worksheet.
Steps
Unhide a line
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f0/Unhide-Rows-in-Excel-Step-1-Version-10.jpg/v4-460px-Unhide-Rows- in-Excel-Step-1-Version-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f0/Unhide-Rows-in-Excel-Step-1- Version-10.jpg/v4-728px-Unhide-Rows-in-Excel-Step-1-Version-10.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel document. Double-click the Excel document you want to open.
Find hidden lines. You will see the line number displayed to the left of the text while dragging the scroll bar down; if you see a number that is not visible (for example, right after line 23 is line 25 ), then the line between these two numbers is hidden (in the example lines 23 and 25 , line 24 is hidden) . You will also see a double dashed line in between these two lines. [1] X Research Source
Right click in the space between the two lines. This will open a menu.
- For example, if line 24 was hidden, you would click in the space between 23 and 25 .
- On a Mac, you can press the Contrp key while clicking this empty space to open the menu.
Click Unhide . This is an option in the currently displayed menu. This makes the hidden line reappear.
- You can save your changes by pressing Ctrl + S (on Windows) or ⌘ Command + S (on Mac).
Unhide multiple contiguous lines. If you notice a lot of lines are hidden, unhide them all with the following:
- Press Ctrl (on Windows) or ⌘ Command (on Mac) while you click the lines above and below the hidden lines.
- Right click on one of the selected lines.
- Click Unhide in the pop-up menu.
Unhide all hidden lines
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/90/Unhide-Rows-in-Excel-Step-7-Version-8.jpg/v4-460px-Unhide-Rows- in-Excel-Step-7-Version-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/90/Unhide-Rows-in-Excel-Step-7- Version-8.jpg/v4-728px-Unhide-Rows-in-Excel-Step-7-Version-8.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel document. Double-click the Excel document you want to open.
Click the “Select All” button. This rectangular button displays in the upper-left corner of the sheet, just above line # 1 and to the left of column header A . This is the operation to select the entire Excel sheet.
- You can also click on any line in the text and press Ctrl + A (on Windows) or ⌘ Command + A (on Mac) to select the entire sheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a4/Unhide-Rows-in-Excel-Step-3-Version-7.jpg/v4-460px-Unhide-Rows- in-Excel-Step-3-Version-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a4/Unhide-Rows-in-Excel-Step-3- Version-7.jpg/v4-728px-Unhide-Rows-in-Excel-Step-3-Version-7.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Home tab. This is the tab below the green section at the top of the Excel window.
- If you already have the Home tab open, skip this step.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8e/Unhide-Rows-in-Excel-Step-4-Version-9.jpg/v4-460px-Unhide-Rows- in-Excel-Step-4-Version-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8e/Unhide-Rows-in-Excel-Step-4- Version-9.jpg/v4-728px-Unhide-Rows-in-Excel-Step-4-Version-9.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Format . This is the option in the “Cells” section of the toolbar near the top-right corner of the Excel window. A selection list will appear here.
Select Hide & Unhide . This option is available in the Format menu. You will see another menu show up after the click.
Click Unhide Rows . This is an option in the menu. This will immediately make hidden lines visible on the sheet.
- You can save changes by pressing Ctrl + S (on Windows) or ⌘ Command + S (on Mac).
Line height adjustment
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/37/Unhide-Rows-in-Excel-Step-12-Version-7.jpg/v4-460px-Unhide-Rows- in-Excel-Step-12-Version-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/37/Unhide-Rows-in-Excel-Step-12- Version-7.jpg/v4-728px-Unhide-Rows-in-Excel-Step-12-Version-7.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Know when to use this method. One thing that causes lines to be hidden is that their heights are so narrow they can’t be seen on the sheet. So you can reset the whole sheet’s line-height to “14.4” (default line-height) to fix this issue.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/30/Unhide-Rows-in-Excel-Step-13-Version-8.jpg/v4-460px-Unhide-Rows- in-Excel-Step-13-Version-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/30/Unhide-Rows-in-Excel-Step-13- Version-8.jpg/v4-728px-Unhide-Rows-in-Excel-Step-13-Version-8.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Excel document. Double-click the Excel document you want to open.
Click the “Select All” button. This is the rectangular button in the upper left corner of the sheet, just above line number 1 and to the left of the column header A . This will select the entire Excel sheet.
- You can also click any line in the worksheet and press Ctrl + A (on Windows) or ⌘ Command + A (on Mac) to select the entire sheet.
Click the Home tab. This is the tab below the green section at the top of the Excel window.
- If you already have the Home tab open, skip this step.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/eb/Unhide-Rows-in-Excel-Step-16-Version-5.jpg/v4-460px-Unhide-Rows- in-Excel-Step-16-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/eb/Unhide-Rows-in-Excel-Step-16- Version-5.jpg/v4-728px-Unhide-Rows-in-Excel-Step-16-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Format . This is the option in the “Cells” section of the toolbar near the top-right corner of the Excel window. Another menu will display here.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/34/Unhide-Rows-in-Excel-Step-17-Version-5.jpg/v4-460px-Unhide-Rows- in-Excel-Step-17-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/34/Unhide-Rows-in-Excel-Step-17- Version-5.jpg/v4-728px-Unhide-Rows-in-Excel-Step-17-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Row Height… (Line height…). This option is available in the currently displayed menu. You will see a new window appear with a blank text input line.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/36/Unhide-Rows-in-Excel-Step-18-Version-5.jpg/v4-460px-Unhide-Rows- in-Excel-Step-18-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/36/Unhide-Rows-in-Excel-Step-18- Version-5.jpg/v4-728px-Unhide-Rows-in-Excel-Step-18-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the default line height. Enter 14.4 in the text input field of the currently displayed window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ec/Unhide-Rows-in-Excel-Step-19-Version-5.jpg/v4-460px-Unhide-Rows- in-Excel-Step-19-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ec/Unhide-Rows-in-Excel-Step-19- Version-5.jpg/v4-728px-Unhide-Rows-in-Excel-Step-19-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click OK . This will apply the changes to the entire line in the worksheet, and unhide lines that have been “hidden” by adjusting the line height.
- You can save your changes by pressing Ctrl + S (on Windows) or ⌘ Command + S (on Mac).
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 122,680 times.
This is an article that shows you how to unhide one or more lines in a Microsoft Excel worksheet.
Thank you for reading this post How to Unhide Lines in Excel at Lassho.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: