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 ddalgleish@contextures.com

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:

  1. 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.
  2. 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.
  3. 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.
  4. 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!


Contextures Products

Save time with our "Done For You" Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.