Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures May 7, 2012

Create multiple copies of a pivot table, confuse your co-workers with happy face column headers, and other tips, in this week's Excel news from Contextures.

 -  Debra ddalgleish@contextures.com
 

Create Multiple Copies of Excel Pivot Table

Use a built-in feature to quickly create multiple copies of an Excel pivot table, such as one per department or region. No macros are needed.

Click here to read the article on my Excel Pivot Table blog: Create Multiple Copies of Excel Pivot Table

Change Font in Excel Column Headers

You can change the font and font size in your workbook's column and row headers. For example, change from Arial 11 to Times New Roman 12. Or use this technique to confuse your co-workers - use a graphic font, like Wingdings, to show pictures instead of letters in the Excel column headers

Click here to read the article: Change Font in Excel Column Headers

Excel Data Validation Combo box Codes

With a bit of programming in Excel, you can show a description in a combo box, but enter the matching code for the selected item into the cell.

Click here to see the details, and download the sample file: Excel Data Validation Combo box Codes

Working with Circular references in Excel

You've probably encountered a few accidental circular reference errors in Excel, and you know how frustrating it can be, to try to fix them.
 
Excel MVP, Jan Karel Pieterse has a new article on his website, that will help you sort out these errors.

Click here to read Jan Karel's article: Working with Circular references in Excel

Copy Chart as a Picture

On the Daily Dose of Excel blog, Rob van Gelder shared his code to copy an Excel chart as an enhanced metafile (EMF) which is a format that scales well when the page resizes.

Click here to see Rob's VBA example: Copy Chart as a Picture

Recommended Excel Tools

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

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.