Excel Worksheet Button Trick
February 26, 2019
What’s in your workbook, worksheet button trick, and extra, in this week’s Excel information. Check out my Excel web site for additional guidelines, tutorials and movies, and examine the index for earlier difficulties of this newsletter.
Notice: For some items talked about down below, I get paid a commission on income. That will help help the totally free tutorials on my internet site.
Workbook Details
What’s in your workbook? If you have to use an Excel file that someone else crafted, or a file that you designed prolonged back, I have received a couple of macros that will support you locate out what’s hiding in there.
The first macro lists all the pivot tables in your workbook, with specifics on where they are situated, and the source information, There’s a website link to each and every pivot desk, so it can be easy to uncover it, when you are troubleshooting.
The second macro lists all the described names in your workbook. The listing displays the title, its Refers To formula, the selection of cells in the selection, its area, and the scope (workbook or worksheet).
Down load the sample data files to get the macros, then include them to your individual workbooks. Or, make them easy to operate, by introducing them your Personalized Macro Workbook
Button Trick
If you have buttons or designs on a worksheet, you can get the caption textual content from a worksheet mobile, as a substitute of typing the textual content in the shape. This is equivalent to the cereal box text in my “Swap Languages” weblog publish.
In this instance, the button is joined to cell E2, which has a formulation that checks the amount:
=IF(C1<=40,"See price", "See discounted price")
- Click on the button to select it
- Click in the Formula Bar, and type an equal sign =
- Click on the cell with the text for the button, and press Enter
Product Updates
Ctx Excel Tools – There’s a new version of my Excel Tools add-in (1.91), with minor updates. Use your original download link to get the latest version, and email me if you need a new link.
- 2 new commands for data validation documentation lists – DV with Names, and DV with Details
- new command to change formatted numbers to text, keeping leading zeros, dashes, etc.
Chart Tools – Jon Peltier released an update to his Excel Charting Utilities, so contact Jon if you need the new version.
Excel Articles
Here are a couple of Excel articles that you might find useful or interesting.
VisiCalc – This video is for spreadsheet nerds only! Dan Bricklin did a VisiCalc demo for a college class recently, and focused on its interaction techniques. The VC demo is about 45 minutes, and he shows Excel too. See my notes about the video. (Level – All)
Decisions – Can Excel help you make decisions? This Decision Matrix Template is a Google Sheet, but after you open the sheet, click the File menu, then Download As, and choose the Excel option. The article explains how to use it, and there’s an example sheet in the workbook. (Level – All)
Also see: My Excel Products || Excel Events || Previous Issues || Weekly Humour
Altered Book
Our granddaughter came to visit on the weekend and we tried a new art project – Altered Books. You start with an old book that nobody wants anymore, and turn it into a new book. Our book was called “How to Remodel Your Family Room”, and now it’s about Lighting and History.
To alter the book, you glue in pictures, or add paint, or other creative ideas. There are tutorials on the Altered Book Lover blog, if you’d like to try it. We’re just getting started, and so far, it’s lots of fun. And a nice break from spreadsheets!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2019/20190226ctx.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
dsdalg@ gmail.com
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.
No comments:
Post a Comment