Search Contextures Sites


Newsletter Index


Get weekly Excel tips from Debra




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures June 11, 2012

Compare sales in pivot tables, automatically fit merged row height, understand Excel sorting, and other tips, in this week's Excel news from Contextures.

 -  Debra

Compare Top and Bottom Sales in Pivot Table

If you're working on a sales plan, you might want to compare your company's best and worst product sales. Which products give the best return on your marketing efforts? How many bottom products to equal sales of top products?
An easy way to make these comparisons is to use Excel Pivot Tables. Click here to read the article: Compare Top and bottom Sales with Pivot Tables

Autofit the row height for Excel merged cells

Last week I was working on a client's Excel file, and we needed to use merged cells. Even though single cells with wrap text automatically adjust when more text is added, merged cells don't.
My client's Excel sheets need to be printed, and all the text in those merged cells has to show in the cell. With a bit of programming, I solved the problem.
See how to autofit the row height for Excel merged cells: Autofit the row height for Excel merged cells

Sorting and Comparing the Excel Way: Code Pages and Collating Sequences

Excel sorting seems like a simple task, but Excel MVP Charles Williams explains the intricacies of the task.

Click here to read the article: Sorting and Comparing the Excel Way

Program Excel with IronSpread Plug-in

IronSpread is an Excel 2010 plugin for Windows that lets you script your spreadsheets with Python. I'm not familiar with Python programming, but there is documentation on the IronSpread site, and a quick start guide.

A short video on the site also shows you how the plug-in works. Click here to visit the IronSpread website

Contextures Products

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




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.