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. The tab areas now have a light gray color and are outlined. Upon opening: The top portion of the worksheet (quick access toolbar and tab areas) was gray - it is normally green. This evening Excel presented very differently. Wow, it worked! I see the Rows (B16-B18) now!!! The mystery of hidden rows in Excel is solved! I have used my excel (MS Office 2016) for 5 years, no issues. 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. As shown below, I was NOT able to unhide the rows, even on this copied ‘Timeline (2)’ sheet. 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. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.I recently came across an issue of Hidden Rows in Excel. For the benefit of anyone else having this issue we have found that you can replicate the same functionality by adding the 'Send' option to the quick access toolbar via the options menu in the respective apps. If you have extra questions about this answer, please click "Comment". If the answer is helpful, please click "Accept Answer" and kindly upvote it. If there are other versions, you can also replace the existing one. I also suggest you reinstall the graphics driver. Safe Mode can help us troubleshoot the COM Add-ins and startup items. Please hold on Ctrl key, click or double-click Word icon, until Word asks you start Word in safe mode, then please release Ctrl key and click "Yes". Do other Office apps, such as Excel and PowerPoint encounter with the same issue?. If these users are using multiple monitors, it is recommended to just connect a primary monitor temporarily and disconnect others to have a check. If not, I would suggest your users try following steps to have a check. Thanks for your screenshot, I want to confirm that are three dots in the upper corner? If yes, you can click this icon to show the Ribbon.
0 kommentar(er)
