FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

March 15, 2016

Hi fellow Excel Addict,

Well after a pretty great winter like we've just had in eastern Newfoundland, a great spring may be too much to ask for. It's just a week away from the start of spring but, in the last two days, it's been more winterlike than it was in mid-January. Maybe I jinxed it when I bragged about my crocuses coming up in February.

Despite the cold weather, I am happy to say that I have finally started running again after a year-and-a-half layoff due to a knee injury. It feels SO good to be running again, even if it is -8C (18F).

Francis Hayes (TheExcelAddict.com)Francis Hayes (TheExcelAddict.com)Francis Hayes (TheExcelAddict.com)

In last Thursday's 'Excel in Minutes' newsletter, I showed you how to 'Sort Numbers Regardless of Their Signs'. If you missed it you can read it here.

If you have a favourite tip that you'd like to share, or a problem that you've been trying to solve, that I could possibly include in my newsletter, please send it along to me.

Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)

TheExcelAddict.com Quote of the Day

"It's supposed to be HARD.
If it wasn't hard, everyone would do it.
The HARD is what makes it GREAT"

-- A League of Their Own --




If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

Show Pivot Table Data In Separate Columns

When you create a Pivot Table, the row labels are combined into a single column. This is called Compact Form layout and is the default setting for Pivot Tables since 2010. However, many people prefer to have their Pivot Table data in separate columns.

Pivot Table Combined Data In Columns_in_Microsoft_Excel_2007_2010_2013_2016_365

To separate the 'Row Label' fields into separate columns...

1) Select any cell in the Pivot Table and a Pivot Table Tools tab will appear on the Ribbon;

2) Click the
Pivot Table Tools/Design tab;

3) Click the Report Layout command;

4) Finally, choose Show in Tabular Form.

Each 'Row Label' field will now be shown in a separate column in your Pivot Table.

Pivot Table Data In Separate Columns_in_Microsoft_Excel_2007_2010_2013_2016_365



Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630