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
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
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
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
Here are a few of the Excel articles that I read recently, that you might find useful:
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!.
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.
Contextures Inc., Copyright ©2019
All rights reserved.