Contextures

Contextures News 20190813

Excel Toolbar Tip

August 13, 2019

Search Form Builder, toolbar tip, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

You'll get my next newsletter in 2 weeks -- we're on the summer schedule now.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Toolbar Tip

Did you know that you can add commands on the Quick Access Toolbar (QAT), and only see them when a specific workbook is open?

For example, if you add lots of comments in your Budget file, put the Insert Comment command on the QAT, for that workbook only. Here are the steps:

  • Open the Budget workbook
  • At the right end of the QAT, click the drop down arrow, and click More Commands
  • In Excel Options, in the drop down at top right, choose your Budget workbook
  • In the list of commands at the left, find the Insert Comment command, and add it to the QAT.
  • Click OK, to close the Excel Options window.

The Insert Comment command will only appear on the QAT when the Budget workbook is active.

QAT command for specific workbook only

There's a video on my Contextures site that shows the steps, and more tips for the QAT.

Product Update

If you have my Excel UserForms for Data Entry (UFDE) kit, there's a new bonus for you --the Search Form Builder add-in. Watch the 2-minute video, to see how it works.

Select a cell in an Excel Table, and the SFB add-in will help you build a quick UserForm, based on that table. Enter criteria in the 2 search boxes, then find and update existing records, or add new records.

To get the latest version of UFDE, use the download link from your original purchase, or email me, if you need a new link.

And if you want to learn how to build an Excel UserForm from scratch, there are free tutorials on my Contextures site.

Excel Articles

Here are a couple of Excel articles that you might find useful or interesting.

Dashboards: Mynda Treacy shows how to make impressive interactive dashboards, using built-in Excel features, in her one-hour free webinar. Mynda offers full dashboard courses too - get 20% off if you register by this Thursday, Aug 15th. Click here for Excel Dashboard Course or Power BI Course info.

Excel Uses - If you get tired of doing financial things in Excel, Kat Boogaard shows 21 different uses for Excel. Number 6 is my old seating plan workbook, and there's a newer version now. (Level - All)

Data Viz: The Science Goddess built an amazing display of student data, with "stars" in "constellations". This could inspire you to find new ways to present your data in Excel. (Level - All)

Also see: My Excel Products || Excel Events || Previous Issues || Weekly Humour

Camp Crafts

If you ever went to summer camp, you probably made something with popsicle sticks. My granddaughter and I found instructions for a popsicle stick abacus, and had lots of fun making one. It was a bit tricky to put it together, without all of the beads getting stuck in the glue, but we succeeded! Now we just have to learn how to use it.

weekly photo

NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2019/20190813ctx.html
I'll also post any article updates or corrections there.

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
dsd@ contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: August 10, 2019 5:19 PM