LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter lines with Pivot table and non pivot table columns Grover Charts and Charting in Excel 4 September 28th 07 03:16 AM
Filter lines with Pivot table and non Pivot table columns Grover Excel Discussion (Misc queries) 1 September 26th 07 12:48 AM
Pivot table - sum of columns LauriS Excel Discussion (Misc queries) 1 May 23rd 07 04:40 PM
How do I get more columns in a pivot table? Socal Tom Excel Discussion (Misc queries) 0 February 4th 06 08:23 PM
Pivot Table Creating New Columns that Subtract Two Existing Columns den4673 Excel Discussion (Misc queries) 3 December 17th 04 01:31 PM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"