And if you’ve noticed that excel just isn’t cutting it for your organization’s needs anymore, check out this post on Outgrowing Microsoft Excel. In that case, proceed to the next workaround. Note: If the ‘Hide’ tab under the View menu is greyed out, the sheet you’re trying to open is not hidden. Now to figuring out why those two Totals don’t match, that’s another story. Tune back in to see what the solution is for that. Solution: Unhide Excel File Verify if your Excel worksheet is hidden by following these steps: In Excel, click the View tab, and then click Unhide. Wow, it worked! I see the Rows (B16-B18) now!!! The mystery of hidden rows in Excel is solved! Now let me see if I am able to Unhide the Rows. Let me press the Clear Filter icon shown below. I see it does appear that something is being filtered. Hmm, why does it say Filter Mode? I’m not filtering anything on this sheet. (Marked as bold, Also change the blue highlighted part with your excel file path) Change the red highlighted part with green highlighted part in your code after pasting these 2 bold lines. Change the two lines of code that starts prior to line starting with. As shown below, I was NOT able to unhide the rows, even on this copied ‘Timeline (2)’ sheet. Select the table & go to advanced editor. I am simply going to Copy the problematic ‘Timeline’ sheet to a new sheet, within the same spreadsheet, to see if the problem exists. The problem appears to be limited just to the existing Sheet I am currently experiencing the problem with. Let’s get this resolved today. I think I am going to, first of all, add a new sheet to the existing spreadsheet, to confirm whether the issue exists there.Īs shown above there is NO issue using Unhide Rows in the same spreadsheet I am currently experiencing this problem with. It’s 2:00AM now… What Didn’t Work – Round 2īack to it. I decided to also unhide the columns that were on the sheet. Then proceeded with trying to Unhide the Rows. Tried to Unhide the Rows after unfreezing the panes. Of course, I do need to Unfreeze Panes as shown below. Selected the Cells icon again from the Home tab.įound something on Google that said you may also have to ensure you have NO frozen panes to Unhide your rows. Selected the row before and after the ones I wanted to unhide.Selected Visibility/ Hide & Unhide/ Unhide Rows.Selected the Cells icon on the Home page tool bar.Select whole worksheet in upper left corner.Tried several things, including the following: This is a KEY Estimation spreadsheet, with a lot of vested time already put into it. I just need to figure out why my current spreadsheet will NOT allow me to unhide the rows. I was able to Unhide Row 7 as shown below: I know recently I received an automatic Excel update, which was after the spreadsheet above was initiated. Let’s figure this mystery out!įirst of all, let me just see if this is possible via a new spreadsheet. However, after I hid it, once again, Excel did NOT allow me to unhide it. I decided to try to hide another row and unhide it. I just needed to remove that hidden value to confirm it. The assumption, as you can see in the screenshot above, is that there appears to be a 0.1 value in either cells B16/B17/B18. 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. 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 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. I simply could NOT unhide certain rows! Here is my journey to find the solution. Exactly which Office 365 you’re using, which Windows, Public release or Insiders plus images that show what you’re seeing and what you don’t like.I recently came across an issue of Hidden Rows in Excel. Please contact us with your concerns but with DETAILS and IMAGES. Understanding those problems needs hard info from those affected. It seems there are unexplained variations in how Office 365 for Windows is presenting to users. Don’t assume that what you’re seeing is the same as everyone else. We’re not Microsoft and hardly responsible for the changes they make.Īll the messages so far about the new look Office 365 lack detail and especially images. Many people are angry, others are rude and (for some reason) blame us for the changes. We’ve received some messages from people complaining about the new look Office 365. That won’t stop the Office ‘new look’ but it’ll put off the evil day. If the ‘Coming Soon’ option is available, turn it OFF. You could install an earlier build of Office 365 but that would only be a temporary measure. There’s no simple option to return to the old look for Office 365.
0 Comments
Leave a Reply. |