Rearreng Manualy in Pivottable

L

LHM

I want to arreng my raws in Pivot table. In advanced option, It said, "you
can drag items to rearrange them", but I can't do it.
 
S

Shane Devenshire

Hi,

Select a row field cell that for an item you want to rearrange, then move
your mouse along the border until you see a four-headed arrow, then drag up
or down.

Maybe an easier way is to select the item at the location where you want the
first item places and type its name, spelled exactly the same. When you
press Enter the selected item will move to this second postion and that item
will shift down one line. For example, if Florida is in cell F10 and you
want it in F3 where Alabama is, click on F3 and type Florida.
 
R

Roger Govier

Hi

You need to double click the filed name>Advanced and ensure that Sorting is
set to Manual
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top