Excel Weekly News from Contextures Apr 15, 2014

Fix Pivot Subtotals+ more Excel tips

In this week's Excel news, you'll see how to fix date formats in pivot table subtotals, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Change Text to Superscript

There's a Superscript button in Word (shown below), but it's not available in Excel. If you're entering data that needs superscript, such as CO2, it could take a long time to change each character manually. You can try my macro, that quickly changes marked text to superscript.

Click here to see the details, and download the sample file: Change Characters to Superscript

Fix Dates in Pivot Subtotals

If you add subtotals to a pivot table date field, the subtotal date format might be different from the other dates. See why the problem occurs, and learn how to fix it.

Click here to read the details, and download the sample file: Fix Dates in Pivot Subtotals

Center Headings Without Merging

Merged cells can make it difficult to sort or filter in Excel, so I avoid using them, when possible. In this example, I show how to centre headings across several columns, without merging the heading cells.

Click here to see the details: Center Headings Without Merging

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Other Excel Articles

Here are a few of the Excel articles that I read last week, that you might find useful:

Video: Run Macro If Worksheet Changes

If you change a cell on a worksheet, you can set up a macro to run automatically. In this example, if a customer in Canada is selected, a message pops up, reminding you to fill in a customs form..

Spring Colour

We walked through the local park on the weekend, and most of the snow is gone, but there aren't many signs of spring yet. Finally, I found this little tree, with bright pink buds on it. Hooray! Maybe spring will arrive after all.


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.




Privacy Policy


Contextures Inc., Copyright 2017
All rights reserved.