+ Reply to Thread
Results 1 to 2 of 2

Centering Column Title in Pivot Table

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    New York
    MS-Off Ver
    2016
    Posts
    16

    Question Centering Column Title in Pivot Table

    Hi All -

    I have a pivot table with two column values. One value is Period (basically stating which month the data applies to) and then the data column header itself (in this example Hires, Terms, Transfers). I would like to center the Period column header over the actual data values, however, whenever I try to marge and center the title the pivot only changes the data column header itself, instead of the Period/Month header.

    Here is what I currently have:

    Pivot Header example 1.PNG

    Pivot header example 2.PNG

    Here is what I am trying to achieve:

    Pivot header example 3.PNG

    Thanks for the help in advance

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: Centering Column Title in Pivot Table

    In the attached file I selected only the row of the pivot table containing PO1 and PO2. I then pressed the Ctrl + 1 keys to open the format cells dialog box > selected the Alignment tab > changed to Horizontal alignment from general to center across selection > OK
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sum of title in pivot table fields
    By stephme55 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2016, 02:33 PM
  2. Row lables vs. actual field title in pivot table
    By stephme55 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-24-2016, 06:38 PM
  3. Is it possible to use VBA to insert a title into a pivot table?
    By Smudge.Smith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2014, 11:29 AM
  4. How Can I create Dynamic Pivot Table Title?
    By niloufar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2014, 11:38 PM
  5. Unable to Set Title of First Column in Pivot Table
    By PosseJohn in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-01-2012, 03:29 PM
  6. Replies: 2
    Last Post: 07-14-2012, 02:08 AM
  7. Excel 2007 Beta 2: Chart Title Centering Suggestion
    By dzuy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-06-2006, 05:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1