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