Search Contextures Sites
Excel Weekly News from Contextures May 7, 2012Create 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 firstname.lastname@example.org
Create Multiple Copies of Excel Pivot TableUse 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 CodesWith 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 ExcelYou'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 PictureOn 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 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.