Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Natalie
 
Posts: n/a
Default Pivot tables - Headings

Can I change the direction of the text for Pivot table headings?

I have lots of columns with dates and it would be a lot better to have them
sideways.


  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use one of the AutoFormats that has rotated headings, or format the
headings cells.

To use an Autoformat, select a cell in the pivot table
Choose FormatAutoformat
Select a format with rotated headings (Table 5, Table 8, or Table 9)
Click OK

OR, to format the heading cells:
Select the date heading cells in the pivot table
Choose FormatCells
Select the Alignment tab
For orientation, select 90 degrees (type the number, or drag the red diamond
to the top of the dial)
Click OK

"Natalie" wrote:

Can I change the direction of the text for Pivot table headings?

I have lots of columns with dates and it would be a lot better to have them
sideways.


Reply
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
Blank Cells in Pivot Tables Greg Excel Discussion (Misc queries) 1 March 16th 05 09:23 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM
Pivot Tables Barb R. Excel Discussion (Misc queries) 0 March 9th 05 02:35 PM
Product Function in Pivot Tables from Multiple Consolidation Range bbishop222 Excel Worksheet Functions 0 February 22nd 05 04:55 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 01:34 AM


All times are GMT +1. The time now is 08:19 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"