Search Contextures Sites


Newsletter Index


Get weekly Excel tips from Debra




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures Feb 6, 2013

New functions, chart baselines, and other tips, in this week's Excel news from Contextures.

 -  Debra

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

Contextures Products

Save time with our "Done For You" Excel products.


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



Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.