Full-Speed through Summer

I hope you are having a great weekend. It seems in our area that people are enjoying the "last hurrah" of Summer, before school starts up in the very near future.

This past week you should have received an e-mail letting you know about the latest "opening" of Mynda Treacy's updated dashboard course. In case you missed that message, a great way to discover more is to check out her free webinars, here:

     http://www.mothresource.com/141-28-3-30.html

Once you get to the page, scroll down a bit and you'll see that you can sign up for her free webinar on creating interactive dashboards. This is great info, and you'll no doubt pick up some tips you haven't considered before. (Let me know how you enjoy it!)

—Allen
     

ExcelTips (ribbon) for 11 August 2018

Macros extend Excel
Deleting Blank Rows

Got some pesky blank rows in your data that you want to get rid of? This tip provides a wide variety of methods you can use to get rid of them.

Read this tip »

(Thanks to Leslie Glasser, Steve Aprahamian, Ron Summers, Jim Williams, Fred Potter, Bob Beechey, Terry Holmes, James Woolley, Harold Druss, Peter Dillon, John Smith, Nora Abbott, Ron Solecki, Brian Lair, Ryszard Raciborski, Greg Beck, Charlie O'Neill, Patrick Sedgwick, Bob Farey, George Mutter, Jim Morrison, Fred Goodman, Sue York, Rob Jansen, Richard Hutchins, Henk Haringsma, Michael Schaper, Mark Mace, Gamini Hettithanthiri, Sukhdev Dhunna, and Alec Whatmough for contributing to this tip.)

 
Graphics
Protecting a Graphic

Need to make sure that someone cannot delete a graphic in a worksheet? The ability to protect the graphic depends on where you place it and how you protect the worksheet.

Read this tip »

 
Pay a Visit to Formville

Need invoices, statements, receipts, applications, and hundreds of other business forms you can put to use right away? How about if you can get those forms for free? Discover what awaits you in Formville, your destination for free printable business forms.

 
Editing
Ensuring Standard Units During Data Entry

Need to make sure that information entered in a worksheet is always in a given unit of measurement? It's not as easy of a task as one might hope. Here's a discussion of some different techniques you can try out.

Read this tip »

 
Printing
Hiding a Hyperlink on a Printout

Hyperlinks can be real handy in a workbook, but you may not always want them visible when you send the workbook to the printer. Here are a variety of ways you can hide a hyperlink so it doesn't clutter up your printout.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Adding a Hyperlink to the Status Bar

I can add hyperlinks in worksheet cells. Is there a way, however, to place a hyperlink onto Excel's status bar?
—Ali Jabin (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450