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

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:

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)

Toothache Tree

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!.


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.