![]() |
Add Columns to Right in Pivot Table
Good day everyone, I am working with a pivot table which I am trying to
modify. My problem is I am trying to add columns to my table. Each time I add the column it adds it to the left side of the table e.g. I am working with fiscal years which currently ends at FY 2013. I would like to include columns that goes ot to FY 2020 starting at FY 2014 to the right of FY 2013. Appreciate any assistance provided. -- Django |
Add Columns to Right in Pivot Table
If the years are all items in the same field, click on one of the FY
headings, then click the A-Z button on the toolbar. Or, click on one of the headings to select it. Point to that cell's border, and drag to a new position in the heading row. Django wrote: Good day everyone, I am working with a pivot table which I am trying to modify. My problem is I am trying to add columns to my table. Each time I add the column it adds it to the left side of the table e.g. I am working with fiscal years which currently ends at FY 2013. I would like to include columns that goes ot to FY 2020 starting at FY 2014 to the right of FY 2013. Appreciate any assistance provided. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
All times are GMT +1. The time now is 04:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com