Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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 ddalgleish@contextures.com

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:

  • 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).

First Flowers

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.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

________________________

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.