Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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:

  • Jan Karel Pieterse has updated the Startup Problems page on his site, to include the new tool from Microsoft Ė Office Configuration Analyzer Tool (OffCAT) 
  • 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.
  • 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)

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

__________________________

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.

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

________________________

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.