Save yourself hours with these tips and tricks for Microsoft Excel 2003, 2007, 2010, 2013, 365

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

October 13, 2015

"Life is a classroom. Only those willing to be
lifelong learners will move to the head of the class"
-- Zig Ziglar

Hi Excel Addicts,


This week, in addition to my 'Excel in Seconds' tip, I have an extra bonus for you.

Starting today, you will have access to two free Excel Dashboards Webinars. Mynda Treacy is hosting these webinars and will be running them multiple times over the next 7 days, so you can find a date and time that fits your schedule.

If you have already watched Mynda's dashboard Webinar in the past, you can skip down to today's tip.

Webinar 1 is for anyone who creates reports in Excel. It will show you how to use Excel to build an interactive dashboard (as shown in the image link below.
Click on it to see a larger image), with no additional software or add-ins required...just plain old Excel and some data. This is available for Excel 2007/2010/2013/2016 users.

Learn how to build interactive dashboards in Excel 2007/2010/2013/2016

Webinar 2 is for more advanced Excel users. It will showcase how you can use Power Query to get data from multiple sources, mash it up with Power Pivot and analyze it in PivotTables to create an interactive Excel Dashboard (as shown in the image link below. Click on it to see a larger image). This webinar is for Excel 2010/2013/2016 users.

Learn how to build interactive dashboards in Excel 2007/2010/2013/2016

If you are not familiar with Excel Dashboard Reporting, what you will learn here can literally change the way you and your company use Excel to prepare reports.

If you missed Mynda's webinar back in July, you won't want to miss out on this one. Once you discover how quickly and easily dashboard reports can be updated and refreshed, Excel reporting as you know it will never be the same. Can you imagine updating your Excel reports in less than a minute?

And Dashboard Reporting is not just about updating your reports faster. Mynda's dashboard webinar will teach you how to design better, more effective dashboard reports that are much easier for end users to interpret.

Even if your job doesn't require you to create dashboard reports in Excel, just watching one or both of these webinars will teach you dozens of new tips and tricks that you can use in your everyday Excel work.

Comment from past webinar participant: "Most webinars are thinly veiled info-mercials lacking worthwhile content. This webinar contained tips and helpful information that I can actually use right now. Thank you!" -Granville

You can even download the Excel workbooks that Mynda uses in the webinar containing the completed dashboards so you can see how they work.

Why am I promoting Mynda's Excel Dashboards course?
Learn how to build interactive dashboards in Excel 2007/2010/2013/2016Although I have been using Excel for more than 20 years, honestly, I don't know everything. I can't possibly cover every aspect of Excel in my newsletter, so to help you expand your Excel skills even further, I will occasionally be recommending some outside sources that I consider to be 'first class'. Mynda's dashboard course is one of them.

I have known Mynda and her husband Phil for more than two years and have found them to be honest, dedicated and meticulous Excel trainers whose main goal is to give you the best possible training to enhance your skills. They guarantee your satisfaction and so do I.

To date, almost 1000 Excel Addict members have taken Mynda's course and I have heard nothing but high praise for both them and the dashboard course.

To see for yourself why Excel Dashboard Reporting skills are in such high demand, go here to sign up for the Dashboards Webinar.

If you decide to enroll in Mynda's full Dashboards Course, you can save 20% off until October 22. Also, use EXCELADDICT for your coupon code at the Checkout and you will qualify for my exclusive BONUS, which I will be telling you more about later this week.

Enjoy the rest of your week and keep on Excelling,

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com




If you missed my last newsletter, you can click here to view it online.

You can access even more tips on my website by going to my members' page



Excel in Seconds with TheExcelAddict.com

Here's What To Do When Row 1 Is Missing


As you know, hiding and unhiding rows in Excel is simple as selecting them, right-clicking and choosing Hide or Unhide. The trick to selecting hidden rows, is to select a row above or below and then drag to included the hidden rows.

What's not so apparent, however, is how to unhide hidden rows if they are above the first visible row in your worksheet.

For example, if you accidentally hide row 1 of your worksheet or inherit someone else's worksheet with one or more of the top rows hidden, you may be wondering how to unhide them since apparently you cannot select them.

How To Unhide Row 1 in Microsoft Excel 2003, 2007, 2010, 2013, 365
Fortunately, there is a really easy solution.

1) Point to the row 2 header, press the left mouse button and drag upward to the top of the worksheet. Although you cannot see it, row 2 and row 1 are now selected;

2) Right click anywhere on row 2;

3) Choose Unhide from the right-click menu.


Unhide Top Rows in Microsoft Excel 2003, 2007, 2010, 2013, 365

NOTE This also works for multiple hidden rows.

What if that doesn't work?
You may come across a situation where the top several rows of a worksheet appear to be hidden but the solution above doesn't unhide them. In that case, the problem isn't that the rows are hidden. It is more likely that one of the Freeze Panes options has been enabled.

Solution: From the View tab click Freeze Panes. If the Unfreeze Panes option is available, click it to make your rows visible again.

To see this for yourself, try this...

1) Open a new workbook;

2) Scroll down so that the first few rows are no longer visible at the top of the worksheet;

3) From the View tab click, Freeze Panes, Freeze Top Row;

4) Now scroll back up and you'll see that the top rows appear to be hidden;

5) To make them visible again, from the View tab click Freeze PanesUnfreeze Panes .


Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

My records show that {!name} at {!email} requested a subscription to this newsletter at TheExcelAddict.com on {!signdate long}.

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in your company's newsletter or website.

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630