How to Unhide a Row in Excel 2013
Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns. Under Cell Size, click Row Height or Column Width, and then in the Row Height or Column Width box, type the value that you want to use for the row height or column width. . Nov 04, · The row numbers displayed are: 12, 13, 31, 33, 47, 50, 60, When I change the row height, I can see the change in the height of the unhidden rows, but the hidden rows remain hidden. Nothing happens when I select the rows 12, 13, 31, 33, 47, 50, 60, 61 and click on Visibility/Unhide in the Format dropdown box.
This article was written by Jack Lloyd. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. The wikiHow Tech Team also followed the article's instructions what paint can be used on plastic verified that they work. This article has been viewedtimes. This wikiHow teaches you how to force one or more hidden rows in a Microsoft Excel spreadsheet to display.
Open your spreadsheet in Microsoft Excel. Select all data in the worksheet. A quick way to do this is to click the ""Select all"" button at the top-left corner of the worksheet. Click the ""Home"" tab. Click the ""Format"" button in the ""Cells"" section of the toolbar. A menu will expand. Click ""Unhide rows"" to make all hidden rows visible.
Related Articles. Article Summary. Method 1 of Open the Excel document. Double-click the Excel document that you want to use to open it in Excel. Find the hidden row. Look at the row numbers on the left side of the document as you scroll down; if you see a skip in numbers e.
You should also see a double line between the two row numbers. Right-click the space between the two row numbers. Doing so prompts a drop-down menu to appear. For example, if row 24 is hidden, you would right-click the space between 23 and On a Mac, you can hold down Control while clicking this space to prompt the drop-down menu.
Click Unhide. It's in the drop-down menu. Doing so will prompt the hidden row to appear. Unhide a range of rows. Right-click one of the selected row numbers. Click Unhide in the drop-down menu. Method 2 of Click how to record your computer screen with no lag "Select All" button. This triangular button is in the upper-left corner of the spreadsheet, just above the 1 row and just left of the A column heading.
Doing so selects your entire Excel document. Click the Home tab. This tab is just below the green ribbon at the top of the Excel window.
If you're already on the Home tab, skip this step. Click Format. This option is in the "Cells" section of the toolbar near the top-right of the Excel window.
A drop-down menu will appear. You'll find this option how do i uninstall yahoo toolbar from firefox the Format drop-down menu.
Selecting it prompts a pop-out menu to appear. Click Unhide Rows. It's in the pop-out menu. Doing so immediately hoq any hidden rows to appear in the spreadsheet. Method 3 of Understand when this method is necessary. One form of hiding rows involves the height of the row s in question to how much is a pound to euro so short that the row effectively disappears. You can reset the height of all spreadsheet rows to " Click Row Height….
This will open a pop-up window with a blank text field in it. Enter the default row height. Type Click OK. Doing so will apply your changes to all rows in the spreadsheet, thus unhiding any rows which were "hidden" via their height properties. The top 7 rows of my Excel worksheet have disappeared. I've tried to "unhide" from the Format menu, but nothing happens. Gows do I do?
You'll have to unlock the cells via the format unhidthen hide them all before unhiding them. Not Helpful 7 Helpful I have the same problem - top 7 rows aren't displaying. I tried to unlock but they weren't locked and the spreadsheet isn't protected. I can see the top 7 rows only in print preview. There is a possibility you did not hide the rows but reduced your rows' height to minimum. Select all rows above and below of your 7 rows and increase rows height from format menu.
It will re-adjust the height of rows and your rows will be visible. Not Helpful 6 Helpful 2. Include your email address to get a message when this question is answered.
By using this service, some information may be shared with YouTube. Related wikiHows How to. How to. About This Article. Written by:. Jack Lloyd. Co-authors: 7. Updated: November 17, Categories: Microsoft Excel. Article Summary X 1. Deutsch: Versteckte Zeilen 2103 Excel wieder anzeigen.
Nederlands: Verborgen rijen unnide zichtbaar maken in Excel. Ross to all authors for creating a page that has been readtimes. The article solved that problem for me. Is this article up to date? Cookies make wikiHow better. By continuing to use our site, you agree to our exdel policy. Robert Theriault Oct 21,
Thank you for your feedback!
If the first row row 1 or column column A is not displayed in the worksheet, it is a little tricky to unhide it because there is no easy way to select that row or column. Instead, you can use the Name box or the Go To command to select the first row and column. To select the first hidden row or column on the worksheet, do one of the following:.
In the Reference box, type A1 , and then click OK. On the Home tab, in the Cells group, click Format. Tip: The default height for rows is 15 , and the default width for columns is 8. In this picture column A and row 1 are hidden. To unhide column A, right-click the column B header or label and pick Unhide Columns. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. A subscription to make the most of your time. Try one month free. Need more help?
Expand your Office skills. Get instant Excel help. Was this information helpful? Yes No. Any other feedback? The more you tell us, the more we can help. How can we improve? Send No thanks. Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents. Contact Support.