Excel Weekly News from Contextures Nov 05, 2013
Click to print a table + more Excel tips
In this week's Excel news, you'll see how to click a button to print an Excel table, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Block Changes in Excel Drop Down List
With dependent drop down lists, you can select an item in the first column, and the drop down in the second column only shows items from the selected category.
To prevent people from changing the first selection, after they have filled in the second column, you can use this easy data validation trick.
Click here to see the details, and watch the video: Block Changes in Excel Drop Down List
Remove Pivot Table Filters with VBA
You can manually apply and clear pivot table filters, to control what you're seeing in the summarized data. However, for some workbooks, you might prefer to automate the filters with a macro, and have buttons or commands to run those macros.
This article shows how to get started with the Record Macro feature, then tweak the code, to make it flexible.
Click here to see the details: Remove Pivot Table Filters with VBA
Print Excel Table Only Without Print Area
With a built-in Excel command, you can click a button to print an Excel table only, without the other items on a worksheet. You don't need to set a print area, and no macros are required.
Click here to see the details, and watch the video: Print Excel Table Only Without Print Area
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- There are a few dark and mysterious corners in Excel, and the features or formulas that frustate you might be easy for someone else. Chandoo wants to know what scares you in Excel, and take a look at the comments, to see what other people find difficult.
- On her Excel for Educators blog, Science Goddess takes a look at two blogs that feature data visualization examples. One finds good examples, and the other one features the not so good.
- For a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- At the Daily Dose of Excel blog, Dick Kusleika shows how he set up 4 constants in his master Excel template. You might not need constants, but if there anything that you add to almost every workbook, you could put that in the Master file, so it's already set up in every new workbook.
Video: Quickly Select a Large Range
It can be difficult to select a large range of cells, by dragging down a long list of data. Sometimes Excel scrolls too quickly, and you lose track of which row you're on.
This short video shows an easier way to select a large range. Click the first cell in the range, scroll down, press the Shift key, and click on the last cell that you want to select.
Crowded Waiting Room
We're getting close to the winter cold and flu season, here in Canada, so we can expect the doctors' waiting rooms to get a bit crowded. My 3-year-old granddaughter was visiting last week, and she set up a medical practice in the living room. These poor creatures were all waiting quietly, despite their serious injuries. Try to avoid any illnesses this winter, but if you do get sick, I hope your doctor's waiting room looks better than this!
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.