Excel Weekly News from Contextures May 13, 2014
Save custom views + more Excel tips
In this week's Excel news, you'll see how to save custom views with filter and print settings, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
- Show Excel Custom View Name
- Better Pivot Heading Format
- Make Changes to Sample Code
- More Excel Tips
- Video: Switch Column Headings to Numbers
- Weekly Photo: First Flowers
- Excel Tools
Show Excel Custom View Name
To save time when printing reports, you can save filter and print setting in Custom Views. NOTE: Custom Views are not available if the workbook contains a named Excel Table. Then, use formulas to show the name of the selected Custom View, on the main worksheet.
Click here to see the details, and watch the video: Show Excel Custom View Name
Better Format for Pivot Table Headings
When you create a pivot table, Excel applies a default pivot table style. If there are two or more fields in the Row Labels area, you might see dividing lines, below the item headings. These lines can make it difficult to see which group the headings are connected to. To make the pivot table easier to read, you can add blank rows, or create a new pivot table style, with lines above the headings
Click here to read the details, and watch the video: Better Format for Pivot Table Headings
Make Changes to Sample Code
On my website, there are hundreds of Excel sample files that you can download and use. Some of the files contain macros, and you might need to adjust those macros, to use them in your own files. For example, the sample code might run if a cell is changed in column C, and in your workbook, you want it to run in columns B and E. I'll show you a few ways that you can change the code.
Click here to see the details: Modify Excel VBA Code in Sample Files
More Excel Tips
Here are a few of the Excel articles that I read recently, that you might find useful:
- Jon Peltier has finally released a Mac version of his awesome charting utilities add-in. So, if you create complex charts in Excel for the Mac, take at look.
- Chris Woodill explains that sometimes an ordinary pivot table is faster or better than a Power Pivot version.
- Steve Doig shows how to use Excel's tools for data journalism, and shares tips for finding sample data to download.
- Instead of starting from scratch every time you build a new workbook, you can save time with modular spreadsheet development.
- A couple of new Excel books were published last week -- Business Intelligence Tools for Excel Analysts, and Excel Data Analysis for Dummies.
- Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
Video: Switch Column Headings to Letters or Numbers
Usually the worksheet column headings are letters, but sometimes they switch to numbers. If you frequently need to switch the column headings from numbers to letters, or letters to numbers, you can record a macro, to make the task easier.
NOTE: If you've purchased a copy of my PivotPower Premium add-in or Excel Tools add-in, there is a command for this on the Sheets drop down (Toggle Ref Style).
Finally, the first flowers are blooming in our garden, after the long, cold winter. It's nice to see a splash of bright colour, instead of all that dull brown. There's still danger of overnight frost, so we can't plant the annual flowers for a couple of weeks.
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures Excel UserForm Course
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.