Search Contextures Sites
Excel Weekly News from Contextures Feb 6, 2013
New functions, chart baselines, and other tips, in this week's Excel news from Contextures.
- Debra firstname.lastname@example.org
New FORMULATEXT Function in Excel 2013
There is a new function in Excel 2013 -- FORMULATEXT -- that lets you show the text from a cell's formula.
You can use FORMULATEXT for auditing or troubleshooting a worksheet. For example, combine FORMULATEXT with the INDIRECT function, to check the formula in any cell.
To see the details, and to watch a short video tutorial, click here: FORMULATEXT Function
Hide Drop Down Arrows in Pivot Table
When you add a field to the Row Label or Column Label area of the pivot table, its heading cell shows a drop down arrow. When you click the arrow, you'll see Sort and Filter options, for the selected field.
If you want to prevent people from doing manual filtering, you can hide the drop down arrows, by using a bit of Excel VBA programming.
Click here, to get the sample code, and to read the details: Hide Drop Down Arrows in Pivot Table Headings
Add Baseline in Column Chart
On his blog, Excel charting expert, Jon Peltier, shows how to add a baseline in an Excel column chart. There is a long list of steps, but the steps are simple, and the result looks great.
To see the instructions, click here: Another Simple Baseline for Excel Column Chart
Save time with our "Done For You" Excel products.
- Pivot Power Premium Add-in - Time-saving tools for pivot table users
- Data Entry Popup Kit - Quick and easy data entry with a popup list
- Data Entry Search Popup - Enhanced data entry popup, with Search box
- Excel Tools Add-in - Make instant backups, sheet list with links, much more
- More Excel products from Contextures
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.