Search Contextures Sites
Excel Weekly News from Contextures June 11, 2012Compare sales in pivot tables, automatically fit merged row height, understand Excel sorting, and other tips, in this week's Excel news from Contextures.- Debra firstname.lastname@example.org
Compare Top and Bottom Sales in Pivot TableIf 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
Recommended Excel ToolsThey aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.
Contextures Inc., Copyright ©2014
All rights reserved.