Search Contextures Sites

Contextures
Excel news
by email

 

 

 

 

 

Your worksheet formulas can create traffic-light charts, highlight chart elements, assign number formats, and more.

 

 

 

 

 

 

Pivot Table Labels - Moving

Change Order of Pivot Table Labels

When you add a field to the Row Label or Column Label area of the pivot table, its labels are usually sorted alphabetically.

data source list

If you want the labels in a nonalphabetical order, you can manually move them, instead of using the Sort options. The following video shows 3 ways to manually move the labels, and the written instructions are below the video.

TIP: Use can use the same techniques to move pivot fields too. When field names are visible in Outline or Tabular Layout, you can type a field name that isn't in the layout, and it will be added.

Video: Move Pivot Table Labels

This short video shows 3 ways to manually move the labels in a pivot table, and the written instructions are below the video.

Drag Labels to New Position

To move a pivot table label to a different position in the list, you can drag it:

  1. Click on the label that you want to move
  2. Point to the border of the selected cell, and when the pointer changes to a four-headed arrow, drag the cell to its new position. An insertion bar indicates where the label will be dropped

The existing labels shift down, and the moved label takes its new position.

data source list

Use Menu Commands to Move Label

To move a pivot table label to a different position in the list, you can use commands in the right-click menu:

  1. Right-click on the label that you want to move
  2. Click the Move command
  3. Click one of the Move subcommands, such as Move [item name] Up

The existing labels shift down, and the moved label takes its new position.

data source list

Type Over Another Label to Move Label

To move a pivot table label to a different position in the list, you can type its name over another label. Read the warning below, before you try this method.

  1. Click on the cell where you want a different label to appear
  2. Type the name of the label that you want to move
  3. Press Enter

The existing labels shift down, and the moved label takes its new position.

data source list

WARNING: Be careful when using this method. If you type a name that is not an existing label, you will rename the label that you typed over, instead of moving it.

For example, in the screen shot below, I typed "Easter" instead of "East", when typing over the West label. The East label remains in its old position, and the West label has been renamed as "Eastern"

data source list

Type Over Another Label to Add Field

If a pivot field is not in the layout on the worksheet, you can type its name over an existing label, to add it to the layout.

  1. Click on the cell where you want a different field to appear
  2. Type the name of the field that you want to add
  3. Press Enter

The existing fields shift down, and the added field takes its new position.

In the screen shot below, I'm typing "Service" where the District field label is.

data source list

When I press Enter, the Service field is added to the Row area, and District moves to the right.

data source list

Xtreme Pivot Table Course

Pivot table skills are essential, if you want to be an Excel master. To raise your skills to the expert level, I recommend the Xtreme Pivot Table course, from John Michaloudis, at My Excel Online.

This course has more than 200 videos -- beginner, intermediate and advanced level -- along with practice workbooks, finance business cases, and 12 months of personal support. Each short lesson is clear, and easy to follow. Work through the lessons at your own pace, and track your progress. The course is an excellent value, at a surprisingly low price.

See the course details, and watch sample videos here: Xtreme Pivot Table Course.

More Pivot Table Resources

Tutorials:

 

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.

 

Search Contextures Sites