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
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
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
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
Here are a few more Excel articles that I read this week, that you might find useful:
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.
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!
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.
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.