Why does excel hide rows

Remove filter then unhide the rows then Apply Filter. Products 75 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Project Bonsai. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. I checked a few things: 1 Confirmed the Sheet was NOT protected 2 Tried to pull up and down to expand the rows to see if the hidden rows would come into view 3 Inquired with another Workmate via Teams if he knew of some reason that would prevent me from unhiding the rows.

He confirmed NO, but noted that sometimes when that happens, he has to position the cursor on the far left at the line between row numbers then drag up or down to manually resize the row to get it to show up. I ran across this issue because I was comparing totals in a couple of columns, which appeared to have identical derived values, however, the Total was different. The assumption, as you can see in the screenshot above, is that there appears to be a 0. I just needed to remove that hidden value to confirm it.

However, I could NOT get to it. I decided to try to hide another row and unhide it. First of all, let me just see if this is possible via a new spreadsheet. I know recently I received an automatic Excel update, which was after the spreadsheet above was initiated.

I just need to figure out why my current spreadsheet will NOT allow me to unhide the rows. This is a KEY Estimation spreadsheet, with a lot of vested time already put into it. Found something on Google that said you may also have to ensure you have NO frozen panes to Unhide your rows. I did one other thing. Search Advanced search…. New posts. Search forums. Log in. Install the app.

For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Why do my rows automatically hide in Excel? Thread starter Guest Start date Oct 19, At times, there may be information in your worksheet which you no longer need to see.

At other times, you might be printing your worksheet and want to print only columns A—F and columns H—J, skipping column G. Rather than rearrange your worksheet for either of these examples, you can simply hide the information. You can also hide information in specific cells.

You can hide columns of your worksheet containing information that you do not need to view or do not want to print. On the Home command tab, in the Cells group, click Format. The column is hidden. Select at least one cell from both of the columns around the hidden column s to be redisplayed. The column reappears. This option works well for redisplaying column A, since there are not columns on both sides of column A.