If you want to prevent users from wandering into parts of a worksheet you don’t want them to see, then hide such rows from their view. This technique is often used to conceal sensitive data or formulas, but you may also wish to hide unused or unimportant areas to keep your users focused on relevant information.
Another frequent inquiry is “Why do my rows keep hiding in excel?”.
Filtering will hide rows that remain hidden when choosing Unhide Rows, because the filter is still applied. To turn off filtering, select the Data menu, then select Filter, and see if either autofilter or advanced filter has a check-mark by it. If so, un-check it, and your rows should return.
While we were reading we ran into the question “Why can’t I unhide rows in excel?”.
There are generally a few reasons why the rows won’t unhide. If rows are hidden from row 1, it is important to correctly highlight the rows and right click on the correct row. In the example below, you need to highlight all the rows above 9.
One answer is could be your Sheet is Protected, in such case hiding rows is not allowed. Was this reply helpful? Sorry this didn’t help. Thanks for your feedback.
Why can’t I see my hidden rows?
Once you unfreeze them you will be able to scroll upwards and see the hidden rows. If neither of these work, it may just be that the row heights are so small it looks like it is hidden. So when you unhide or unfreeze rows it has no effect.
How do I unhide rows that keep hiding in Excel?
Re: Rows keep hiding themselves. To unhide all rows, select all the spreadsheet using CTRL + A. Then, in the Home tab, click on Format > Hide & Unhide > Unhide Rows.
So, how to unhide a row in Excel?
You see, hold down Ctrl (Windows) or ⌘ Command (Mac) while clicking the row number above the hidden rows and the row number below the hidden rows. Right-click one of the selected row numbers. Click Unhide in the drop-down menu.
How do I hide rows and columns in Excel?
On the Home tab, in the Cells group, click Format. Do one of the following: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns. This thread is locked.
One query we ran across in our research was “How do I unhide a row in a table in Excel?”.
Right-click the selected row headers and pick Unhide Rows. Note: When consecutive columns or rows are hidden, you can’t unhide specific columns or rows. First unhide all the columns or rows, and then hide the ones you don’t want displayed.
Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns. Click the minus sign, the selected rows or column are hidden immediately. And click the Plus sign, the hidden rows or columns are showing at once.
In the “Select Data Source” dialogue box, select “Hidden and Empty Cells” in the bottom left hand corner. In the “Hidden and Empty Cell Settings” dialog box, check the box “Show data in hidden rows and columns”.
How to hide or unhide rows with plus or minus sign in Excel?
Select the entire rows or columns you need to hide or unhide with plus or minus sign, then click Group in the Outline group under Data tab. See screenshot: 2. Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns.
How to hide a row in AutoCAD 2007?
Go to Home tab, click Find & Select, then click Go To. In the Reference box, type A1, and then click OK. 2. Go to Home tab, in the Cells group, click Format then Visibility, then Hide and Unhide, then Unhide Rows.
How do I get rid of row 387 in Excel?
Thanks for your feedback. You can also select row 387 and drag your mouse up slowly until you see a pop-up that tells you that you have selected 387 Rows (see the “21R” pop-up in the image below). Then right-click on row 387 and select “Unhide”.
How do I hide data in a chart?
In the “Hidden and Empty Cell Settings” dialog box, check the box “Show data in hidden rows and columns”. Select “OK” twice. Now, go ahead and hide your data. Your chart should still display with the hidden data!