PC Review


Reply
Thread Tools Rate Thread

Add Columns to Right in Pivot Table

 
 
Django
Guest
Posts: n/a
 
      24th Jun 2008
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
 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      25th Jun 2008
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Columns CherylK Microsoft Excel Worksheet Functions 2 6th May 2010 08:14 AM
Rows to columns in a table or pivot table Jesper Audi Microsoft Excel Misc 4 3rd Nov 2009 07:00 PM
Filter lines with Pivot table and non pivot table columns =?Utf-8?B?R3JvdmVy?= Microsoft Excel Charting 4 28th Sep 2007 03:16 AM
Filter lines with Pivot table and non Pivot table columns =?Utf-8?B?R3JvdmVy?= Microsoft Excel Misc 1 26th Sep 2007 12:48 AM
Pivot Table Creating New Columns that Subtract Two Existing Columns den4673 Microsoft Excel Misc 3 17th Dec 2004 01:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:35 PM.