Can't Unhide Excel Rows
November 22, 2016
Problem unhiding rows, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there.
There are several holidays in the upcoming months, so if you're celebrating any of them, use Excel to help you get organized. If you don't have a planning file of your own, I've updated my Holiday Planner workbook, and you can download the new version. Then, customize it to meet your needs.
Even if you're not planning for the holidays, you'll get some Excel ideas from the template, such as creating a Gantt chart from an hourly schedule, linking sub-budget sheets into a main sheet, and showing which store has the greatest number of low cost items.
While I was updating the Dinner Plan sheet in my Holiday Planner, I noticed that the heading rows were hidden. The visible rows started at 6, instead of 1. So, I selected row 6, dragged up, right-clicked and click Unhide. To my surprise, nothing happened -- the rows were still hidden.
I tried the same steps again, just in case I had done something wrong the first time. Nope, still hidden. Staring at the sheet didn't fix it either, but I finally noticed that the top section was frozen. Doh! I used the Unfreeze Panes command, scrolled up so Row 1 was visible again, and then used Freeze Panes to lock the top section in place.
Apparently this has happened to me before, because I mentioned this problem in my article on locking heading rows in place. I hope your memory is better than mine!
Here are a couple of Excel articles I read recently, that you might find useful.
Hidden Help - Ken Puls posted a great tip for creating hidden help messages on a worksheet. Ken's formula uses AGGREGATE (Excel 2013 or later). In earlier versions, use SUBTOTAL, with 103 as the first argument. Note: If you copy Ken's formula, replace the curly quotes with regular ones. (Level - All)
Power Pivot Problems - If you're having problems with Power Pivot hanging or crashing, Matt Allington would like to hear from you. He is collecting examples of reproducible problems, to help Microsoft fix them. While you're on his site, take a look at the other Power BI articles, from beginner to advanced. (Level - Intermediate/Advanced)
Pivot Table Webinar - Attend this free online training, to learn how easy it is to analyze thousands of rows of data and create interactive Excel Dashboards using Pivot Tables...all with just a few mouse clicks! Choose from 3 different time slots when you register.
Also, see all my Excel products on my Contextures website, and my weekly collection of humorous Excel tweets. For example, "I learned to use pivot tables in excel today, so I'm practically a wizard now"
The nearby park has a few trees that are filled with blossoms in the spring. Then, in the fall, they are loaded with small red fruit. The birds don't seem to eat them, so I guess the fruit isn't too tasty. The trees certainly are pretty though!
Do you know what type of tree it is? In my Google hunt, pictures of Pin Cherry looked similar, but I'm not sure if that's right. There are two more pictures on the Gardening page of my website. Thanks!
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:54 AM