Excel Weekly News from Contextures Mar 25, 2014
Quickly clear data entry cells + more Excel tips
In this week's Excel news, you'll see how to quickly clear data entry cells, without removing the formulas, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
- Change Address of Excel Named Range
- Pivot Table in Excel 2003 Classic Style
- Clear Cells and Leave Formulas
- More Excel Tips
- Video: Quickly Hide Selected Items
- Weekly Photo: Toothache Tree
- Excel Tools
Change Address of Excel Named Range
If you add new items to a named range, the range might not expand automatically to include them. So, if you have a drop down list based on that range, the new items won't appear in the drop down.
Click here to see why this happens, and a couple of options for fixing the problem: Change Address of Excel Named Range
Format a Pivot Table in Excel 2003 Classic Style
If you want the look and drag-and-drop features of the old style pivot tables, you can make a few adjustments to a pivot table in Excel 2010 or 2013.
Click here to see how to set this up: Format a Pivot Table in Excel 2003 Classic Style
Clear Cells and Leave Formulas
If you want to clear out the old data on a worksheet, without deleting the formulas, how would you do it? You can use a built in tool, or get a little fancier, and name the data cells, or even record a macro to do this, if you need to clear them frequently.
Click here to see the details: Clear Cells and Leave Formulas
More Excel Tips
Here are a few of the Excel articles that I read recently, that you might find useful:
- Jan Karel Pieterse has updated the Startup Problems page on his site, to include the new tool from Microsoft Ė Office Configuration Analyzer Tool (OffCAT)
- Jon Peltier explains how to create a Dot Plot chart in Excel. If you make this type of chart frequently, or other complicated chart types, Jon's Chart Utility will save you time and aggravation.
- The IT Portal shares 14 tips for intermediate Excel users. Do you know all of these? Good thing they saved those pie charts for the last tip, or I might not have made it to the end of the article. If you're an Excel power user, you already know the 11 Excel tricks that PC World posted.
- Chandoo has a podcast now, so you can hear him talk about Excel, while you're riding the bus to work. His latest show is about Lookup functions.
- Finally, 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.
Video: Quickly Hide Selected Items in Pivot Table
Instead of scrolling through a long list of items, use this technique to quickly hide or show items in a pivot table. (Excel 2007 and later versions)
Last week, while walking in the park, I stopped to take a picture. I was about to lean on a tree, to help keep the camera steady, but then I noticed all the thorns on it. Yikes! That would have hurt. This tree's nickname is the Toothache tree, because it apparently helps ease the pain, if you chew on its bark. I didn't try it!.
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 Excel Tools Add-in
- 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.