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 -8°C (18°F).
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)
If you missed my last newsletter, you can click here to view it online.
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.
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.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630