Sometimes when you move around your pivot table the PivotTable Field List disappears. To get it back, click any cell with a value. To get it back, click any cell with a value. You can also move or “pivot” your data by right-clicking a data field on the table and selecting the “ Move ” menu.
Join GitHub today
GitHub is home to over 36 million developers working together to host and review code, manage projects, and build software together.
Sign up[INI] |
THIS_LANGUAGE = English |
[GENERAL] |
OK = OK |
PREVIEW = Preview |
CANCEL = Cancel |
YES = Yes |
NO = No |
CONFIRM = Confirm |
OPTIONS = Options |
TYPE = Type |
AXIS = Axis |
X-AXIS = X-Axis |
Y-AXIS = Y-Axis |
Z-AXIS = Z-Axis |
WIDTH = Width |
HEIGHT = Height |
DEPTH = Depth |
COLOR = Color |
COLORS = Colors |
UP = Up |
DOWN = Down |
RIGHT = Right |
LEFT = Left |
CENTER = Center |
BACK = Back |
FRONT = Front |
TOP = Top |
BOTTOM = Bottom |
RESET_TO_DEFAULT = Reset To Default |
UNIFORM = Uniform |
DEGREES = Degrees |
NAME = Name |
AREA = Area |
ALL = All |
NONE = None |
DIRECTION = Direction |
HORIZONTAL = Horizontal |
VERTICAL = Vertical |
EMPTY = Empty |
HIDDEN = Hidden |
VISIBLE = Visible |
LOCKED = Locked |
UNLOCKED = Unlocked |
NEXT = Next |
PREVIOUS = Previous |
FIRST = First |
LAST = Last |
RESET = Reset |
CLEAR = Clear |
PAN = Pan |
ZOOM = Zoom |
OFFSET = Offset |
ENABLED = Enabled |
INFO_SINGULAR = Info |
INFO_PLURAL = Info |
ALL_COLORS = All Colors |
FAVORITES = Favorites |
PROPERTIES = Properties |
SUPPORTED_FILE_TYPES = Supported File Types |
SIZE = Size |
ROTATION = Rotation |
CURSOR = Cursor |
COLOR_MIXER = Color Mixer |
WARNING = Warning |
ABORT = Abort |
UNITS = Units |
LANGUAGE = Language |
[MESSAGES] |
WARNING_FILE_ALREADY_EXISTS = File already exists. Do you want to overwrite it? |
WARNING_FILE_NO_SAVED = Save changes to the file before closing? |
WARNING_ACTION_CANT_BE_UNDONE = This action can't be undone. Are you sure you want to continue? |
WARNING_NAMES_ARE_NOT_UNIQUE = Not all object names are unique. Please save and reload your file to resolve this issue. |
WARNING_MESH_EXPORT_OVERSIZE = The export may take some time because at least one object is very big. Continue anyhow? |
MESSAGE_SUCCESSFUL_UPLOAD_TO_SKETCHFAB = Your model was successfully uploaded to Sketchfab. Do you want to watch your model online now? |
MESSAGE_SUCCESSFUL_UPLOAD_TO_IMATERIALISE = Your model was successfully uploaded to i.materialise and will now open in your browser. |
MESSAGE_CLEAR_BEFORE_ADDING_COLORS = Clear color map before adding new colors? |
MESSAGE_UPDATE_AVAILABLE = An update is available. Open the Update Center in your browser? |
MESSAGE_QUBICLE_IS_UP_TO_DATE = Qubicle is up-to-date. |
MESSAGE_LICENSE_REMOVED = License successfully removed. |
MESSAGE_EXPORT_SUCCESS = Export finished successfully. |
MESSAGE_DEMO_MODE_EXPORT = Demo Mode: This feature can only be tested on a built-in test model. |
MESSAGE_MESH_DLC_REQUIRED = This feature requires the Mesh DLC |
MESSAGE_ABORT_OPERATION = Are you sure you want to abort current operation? |
[MENU_QUBICLE_OSX] |
HIDE_QUBICLE = Hide Qubicle |
HIDE_OTHERS = Hide Others |
SHOW_ALL = Show All |
QUIT_QUBICLE = Quit Qubicle |
[MENU_FILE] |
FILE = File |
NEW_MODEL = New Model |
NEW_MATRIX = New Matrix |
NEW_COMPOUND = New Compound |
OPEN = Open |
RECENT_FILES = Recent Files |
TEST_FILES = Test Files |
CLOSE = Close |
SAVE = Save |
SAVE_AS = Save As |
IMPORT = Import |
ALL_SUPPORTED_FILES = All Supported Files |
QUBICLE_FILES = Qubicle Files |
VOXEL_FILES = Voxel Files |
IMAGE_FILES = Image Files |
IMPORT_HEIGHTMAP = Import Heightmap |
EXPORT_AS = Export As |
EXPORT = Export |
CUBES = Cubes |
SLICES = Slices |
SHARE_ON_SKETCHFAB = Share on Sketchfab |
3D-PRINT_WITH_IMATERIALISE = 3D-Pint with i.materialise |
FILE_INFO = File Info |
FILE_INFO_PRESETS = File Info Presets |
QUIT = Quit |
[DIALOG_IMPORT_HEIGHTMAP] |
HEIGHTMAP = Heightmap |
TEXTURE = Texture |
MAX_HEIGHT = Max Height |
[DIALOG_EXPORT_QB] |
LEFT-HANDED = Left-Handed |
RIGHT-HANDED = Right-Handed |
COLOR_FORMAT = Color Format |
COMPRESSION = Compression |
ENCODE_VISIBILITY_MASK = Encode Visibility Mask |
INDIVIDUAL_EXPORT = Individual Export |
[DIALOG_EXPORT_FBX_OBJ_DAE] |
MESH = Mesh |
OPTIMIZATION = Optimization |
NON-MANIFOLD = Non-Manifold |
MANIFOLD = Manifold/Watertight |
FACES_FRONT_BACK_LEFT_RIGHT_TOP_BOTTOM = Faces (Front Back Left Right Top Bottom) |
AS_SPECIFIED = As Specified |
CENTERED = Centered |
WORLD_ORIGIN = World Origion |
LOCAL_WORLD_ORIGIN = Local World Origion |
LOCAL_PIVOT = Local Pivot |
VOXEL_SIZE = Voxel Size |
UNIT_SCALE_FACTOR = Unit Scale Factor |
MATERIAL = Material |
TEXEL_SIZE = Texel Size |
EDGE_BLEED = Edge Bleed |
OUTPUT = Output |
SINGLE_FILE = Single File |
ONE_FILE_PER_OBJECT = One File Per Object |
MESH_FILENAME_PREFIX = Mesh Filename Prefix |
TEXTURE_FILENAME_PREFIX = Texture Filename Prefix |
TEXTURE_SUBFOLDER = Texture Subfolder |
CREATING_MESH = Creating Mesh |
CREATING_TEXTURE = Creating Texture |
FINALIZING = Finalizing |
WRITING_FILES = Writing files |
[DIALOG_EXPORT_STL] |
SINGLE_STL_FILE = Single STL File |
BINARY = Binary |
[DIALOG_SHARE_ON_SKETCHFAB] |
MODEL_NAME = Model Name |
DESCRIPTION = Description |
SIGNATURE = Signature |
TAGS = Tags |
SKETCHFAB_API_TOKEN = Sketchfab API Token |
REMEMBER_TOKEN = Remember Token |
PRIVATE = Private |
PASSWORD = Password |
UPLOADING_3D_DATA = Uploading 3D Data |
[DIALOG_FILE_INFO] |
TITLE = Title |
KEYWORDS = Keywords |
CREATOR = Creator |
COMPANY = Company |
WEBSITE = Website |
COPYRIGHT = Copyright |
[MENU_EDIT] |
EDIT = Edit |
UNDO = Undo |
REDO = Redo |
CLEAR_UNDO_HISTORY = Clear Undo History |
CUT = Cut |
COPY = Copy |
PASTE = Paste |
PASTE_WINDOWS_CLIPBOARD = Paste Windows Clipboard |
PASTE_OS_X_CLIPBOARD = Paste OS X Clipboard |
DELETE = Delete |
DUPLICATE = Duplicate |
DUPLICATE_SPECIAL = Duplicate Special |
EDIT_ISOLATED = Edit Isolated |
EDIT_IN_PLACE = Edit In Place |
EDIT_ROOT_OBJECT = Edit Root Object |
STATUS = Status |
SHOW = Show |
HIDE = Hide |
LOCK = Lock |
UNLOCK = Unlock |
PREFERENCES = Preferences |
[DIALOG_DUPLICATE_SPECIAL] |
NUMBER_OF_COPIES = Number of Copies |
[DIALOG_EDIT_NAME] |
EDIT_NAME = Edit Name |
NEW_NAME = New Name |
[DIALOG_PREFERENCES] |
VARIOUS = Various |
SHIFT_NUDGE_SIZE = Nudge With Shift + Arrow |
ACTIVATE_WITH_DBL_CLICK = Activate with Dbl-Click |
REFRESH_RATE = Refresh Rate |
FPS = fps |
POPUP_WINDOW_POSITION = Popup Window Position |
START_NEW_FILE_WITH_EMPTY_MATRIX = Start new File with Empty Matrix |
SHOW_TOOLTIPS_IN_COLOR_MAP = Show Tooltips in Swatch Bar |
OVERSIZE_WARNING = Oversized Warning |
TOOL_WHEEL = Tool Wheel |
SLOT = Slot |
CUSTOM = Custom |
INDIVIDUAL_ADVERB = Individual |
[MENU_CREATE] |
CREATE = Create |
EMPTY_MATRIX = Empty Matrix |
BOX = Box |
SPHERE = Sphere |
CYLINDER = Cylinder |
CONE = Cone |
PYRAMID = Pyramid |
TORUS = Torus |
RECTANGLE = Rectangle |
DISC = Disc |
TRIANGLE = Triangle |
TERRAIN = Terrain |
CREATE_EMPTY_MATRIX = Create Empty Matrix |
CREATE_BOX = Create Box |
CREATE_SPHERE = Create Sphere |
CREATE_CYLINDER = Create Cylinder |
CREATE_CONE = Create Cone |
CREATE_PYRAMID = Create Pyramid |
CREATE_TORUS = Create Torus |
CREATE_RECTANGLE = Create Rectangle |
CREATE_DISC = Create Disc |
CREATE_TRIANGLE = Create Triangle |
CREATE_TERRAIN = Create Terrain |
[DIALOG_CREATE_TRIANGLE] |
POINT_VERB = Point |
[DIALOG_CREATE_TORUS] |
OUTER_RADIUS = Outer Radius |
INNER_RADIUS = Inner Radius |
[DIALOG_CREATE_TERRAIN] |
DIMENSION = Dimension |
ROUGHNESS = Roughness |
SMOOTHNESS = Smoothness |
SMOOTH_INTERATIONS = Smooth Iterations |
COLORING = Coloring |
SURFACE = Surface |
UNDERGROUND = Underground |
GRADIENT = Gradient |
TOOL_COLOR = Tool Color |
BLACK = Black |
WHITE = White |
BLACK_AND_WHITE = Black And White |
DESERT = Desert |
GRASSLAND = Grassland |
MOUNTAIN = Mountain |
TROPICAL = Tropical |
SHADOWS = Shadows |
ADD_SHADOWS = Add Shadows |
SUN_POSITION = Sun Position |
RANDOMIZE = Randomize |
[MENU_TRANSFORM] |
TRANSFORM = Transform |
ALIGN = Align |
LEFT_EDGES = Left Edges |
RIGHT_EDGES = Right Edges |
TOP_EDGES = Top Edges |
BOTTOM_EDGES = Bottom Edges |
HORIZONTAL_CENTERS = Horizontal Centers |
VERTICAL_CENTERS = Vertical Centers |
ALIGN_LEFT_EDGES = Align Left Edges |
ALIGN_RIGHT_EDGES = Align Right Edges |
ALIGN_TOP_EDGES = Align Top Edges |
ALIGN_BOTTOM_EDGES = Align Bottom Edges |
ALIGN_HORIZONTAL_CENTERS = Align Horizontal Centers |
ALIGN_VERTICAL_CENTERS = Align Vertical Centers |
DISTRIBUTE = Distribute |
DISTRIBUTE_LEFT_EDGES = Distribute Left Edges |
DISTRIBUTE_RIGHT_EDGES = Distribute Right Edges |
DISTRIBUTE_TOP_EDGES = Distribute Top Edges |
DISTRIBUTE_BOTTOM_EDGES = Distribute Bottom Edges |
DISTRIBUTE_HORIZONTAL_CENTERS = Distribute Horizontal Centers |
DISTRIBUTE_VERTICAL_CENTERS = Distribute Vertical Centers |
TRANSLATE = Translate |
ROTATE = Rotate |
SCALE = Scale |
INTEGER_SCALE = Integer Scale |
ROTATE_90 = Rotate 90° |
ROTATE_90_X = Rotate 90° X |
ROTATE_90_Y = Rotate 90° Y |
ROTATE_90_Z = Rotate 90° Z |
FLIP = Flip |
FLIP_HORIZONTAL = Flip Horizontal |
FLIP_VERTICAL = Flip Vertical |
FLIP_X = Flip X |
FLIP_Y = Flip Y |
FLIP_Z = Flip Z |
MIRROR = Mirror |
[DIALOG_ALIGN] |
BACK_EDGES = Back Edges |
FRONT_EDGES = Front Edges |
ALIGN_TO_PARENT_WORKAREA = Align To Parent Work Area |
ALIGN_AS_GROUP = Align As Group |
CENTERS = Centers |
[DIALOG_TRANSLATE] |
RELATIVE_ADJECTIVE = Relative |
EDIT_POSITION = Edit Position |
[MENU_MODIFY] |
MODIFY = Modify |
HUE_SATURATION = Hue/Saturation |
BRIGHTNESS_CONTRAST = Brightness/Contrast |
DESATURATE = Desaturate |
INVERT = Invert |
SEPIA = Sepia |
COLOR_OVERLAY = Color Overlay |
GRADIENT_OVERLAY = Gradient Overlay |
ADD_NOISE = Add Noise |
APPLY_COLOR_MAP = Apply Color Map |
FILL = Fill |
RESIZE = Resize |
RESIZE_WORKAREA = Resize Work Area |
OPTIMIZE = Optimize |
EXTEND = Extend |
EXTEND_1_UNIT = Extend 1 Unit |
EXTEND_5_UNITS = Extend 5 Units |
DIVIDE = Divide |
COMPOUND = Compound |
CREATE_COMPOUND = Create Compound |
BREAK = Break |
PARENT = Parent |
UNPARENT = Unparent |
MERGE = Merge |
CROP = Crop |
CORE = Core |
HOLLOW = Hollow |
ADVANCED_HOLLOW = Advanced Hollow |
FILL_HOLLOWS = Fill Hollows |
EXTRACT_CORE = Extract Core |
REMOVE_HULL = Remove Hull |
BOOLEAN = Boolean |
UNION = Union |
DIFFERENCE = Difference |
INTERSECTION = Intersection |
PIVOT = Pivot |
SET_PIVOT_POSITION = Set Pivot Position |
ALIGN_PIVOT_POSITION = Align Pivot Position |
OTHER = Other |
SPLIT_OFF = Split Off |
LINEAR_PROJECTION = Linear Projection |
LINEAR_SNAPSHOT = Linear Snapshot |
COUNT_VOXELS = Count Voxels |
HIGHLIGHT_TJUNCTIONS = Highlight T-Junctions |
CONTIGUOUS = Contiguous |
TOLERANCE = Tolerance |
SWITCH_BACK = Switch Back |
[DIALOG_HUE_SATURATION] |
HUE = Hue |
SATURATION = Saturation |
LUMINANCE = Luminance |
[DIALOG_BRIGHTNESS_CONTRAST] |
BRIGHTNESS = Brightness |
CONTRAST = Contrast |
[DIALOG_GRADIENT_OVERLAY] |
NUMBER_OF_SHADES = Number Of Shades |
REVERSE = Reverse |
[DIALOG_NOISE] |
AMOUNT = Amount |
MONOCHROMATIC = Monochromatic |
[DIALOG_APPLY_COLOR_MAP] |
COLOR_MAP = Color Map |
[DIALOG_RESIZE] |
ANCHOR_X = Anchor X |
ANCHOR_Y = Anchor Y |
ANCHOR_Z = Anchor Z |
[DIALOG_ADVANCED_HOLLOW] |
HULL_THICKNESS = Hull Thickness |
[DIALOG_LINEAR_PROJECTION] |
REPEAT_HORIZONTAL = Repeat Horizontal |
REPEAT_VERTICAL = Repeat Vertical |
PIERCE_OBJECT = Pierce Object |
[DIALOG_DIVIDE] |
DIVISIONS = Divisions |
[DIALOG_COUNT_VOXELS] |
SOLID_VOXELS = Solid Voxels |
HULL_VOXELS = Hull Voxels |
CORE_VOXELS = Core Voxels |
[MENU_SELECT] |
SELECT = Select |
SELECT_ALL = Select All |
DESELECT = Deselect |
INVERT_SELECTION = Invert Selection |
PREVIOUS_OBJECT = Previous Object |
NEXT_OBJECT = Next Object |
BY_TYPE = By Type |
BY_STATUS = By Status |
[MENU_VOXELIZE] |
VOXELIZE = Voxelize |
CREATE_VOXELIZER = Create Voxelizer |
LOAD_MESH = Load Mesh |
SCALE_MESH = Scale Mesh |
ROTATE_MESH = Rotate Mesh |
CONVERT_TO_MATRIX = Convert To Matrix |
[MENU_TOOLS] |
TOOLS = Tools |
MIRROR_X = Mirror X |
MIRROR_Y = Mirror Y |
MIRROR_Z = Mirror Z |
SLICE = Slice |
SLICE_MODE = Slice Mode |
MASK_VERB = Mask |
TRACE_STROKE = Trace Stroke |
APPLY_ATTACH = Apply/Attach |
APPLY_ATTACH_LOSSLESS = Apply/Attach Lossless |
MOVE_TOOL = Move Tool |
RECTANGULAR_SELECT_TOOL = Rectangular Select Tool |
EYEDROPPER_TOOL = Eyedropper |
PENCIL_TOOL = Pencil |
ATTACH_VOXEL_TOOL = Attach Voxel Tool |
ERASER_TOOL = Eraser |
PAINT_TOOL = Paint Tool |
PAINT_BUCKET_TOOL = Paint Bucket |
MAGIC_WAND_TOOL = Magic Wand |
FREEHAND_TOOL = Freehand Tool |
LINE_TOOL = Line Tool |
RECTANGLE_TOOL = Rectangle Tool |
BOX_TOOL = Box Tool |
SPHERE_TOOL = Sphere Tool |
PYRAMID_TOOL = Pyramid Tool |
CONE_TOOL = Cone Tool |
CYLINDER_TOOL = Cylinder Tool |
EXTRUDE_TOOL = Extrude Tool |
PAINT_SELECTION_TOOL = Paint Selection Tool |
BOX_SELECT_TOOL = Box Select Tool |
RESIZE_TOOL = Resize Tool |
[MENU_COLORS] |
PACK_VERB = Pack |
REMOVE_DUPLICATES = Remove Duplicates |
ADD_USED_COLORS = Add Used Colors To Color Map |
CREATE_GRADIENT = Create Gradient |
AUTO_NAME = Auto Name |
CLEAR_NAMES = Clear Names |
SWAP_PRIMARY_SECONDARY_COLOR = Swap Primary/Secondary Color |
DEFAULT_PRIMARY_SECONDARY_COLOR = Default Primary/Secondary Color |
[MENU_CAMERA] |
CAMERA = Camera |
FRAME_VERB = Frame |
FRAME_WORK_AREA = Frame Work Area |
HOME = Home |
PERPENDICULAR_VIEW = Perpendicular View |
ISOMETRIC_VIEW = Isometric View |
NEAREST = Nearest |
CAMERA_PROPERTIES = Camera Properties |
[MENU_RENDER] |
RENDER = Render |
IMAGE = Image |
TURNTABLE = Turntable |
RENDER_IMAGE = Render Image |
RENDER_TURNTABLE = Render Turntable |
[DIALOG_RENDER_TURNTABLE] |
NUMBER_OF_FRAMES = Number Of Frames |
CLOCKWISE = Clockwise |
[MENU_VIEW] |
VIEW_NOUN = View |
WORK_AREA = Work Area |
SCREEN_MODE = Screen Mode |
DEFAULT = Default |
COMPACT = Compact |
MINIMAL = Minimal |
CYCLE = Cycle |
SHADING = Shading |
WIREFRAME = Wireframe |
BOUNDING_BOXES = Bounding Boxes |
GROUND = Ground |
GRID = Grid |
GHOSTS = Ghosts |
RESOLUTION_GATE = Resolution Gate |
CAMERA_LIGHT = Camera Light |
DIRECTIONAL_LIGHT = Directional Light |
MIRROR_WALL = Mirror Wall |
GRID_PROPERTIES = Grid Properties |
WORK_AREA_COLORS = Work View Colors |
MIRROR_WALL_PROPERTIES = Mirror Wall Properties |
BACKGROUND = Background |
WATERMARK = Watermark |
BACKGROUND_PROPERTIES = Background Properties |
RENDER_BACKGROUND_PROPERTIES = Render Background Properties |
WATERMARK_PROPERTIES = Watermark Properties |
GLOBAL_SCALE = Global Scale |
CAMERA_LIGHT_PROPERTIES = Camera Light Properties |
DIRECTIONAL_LIGHT_PROPERTIES = Directional Light Properties |
GLOBAL_SCALE_PROPERTIES = Global Scale Properties |
RESOLUTION_GATE_PROPERTIES = Resolution Gate Properties |
INLINE_MAIN_MENU = Inline Main Menu |
[DIALOG_GRID_PROPERTIES] |
GRIDLINE_EVERY = Gridline Every |
[DIALOG_RENDER_BACKGROUND_PROPERTIES] |
COLOR_TOP = Color Top |
COLOR_BOTTOM = Color Bottom |
[DIALOG_WORK_VIEW_COLORS] |
PRESETS = Presets |
DARK = Dark |
MEDIUM = Medium |
LIGHT = Light |
BACKGROUND_TOP = Background Top |
BACKGROUND_BOTTOM = Background Bottom |
CANVAS = Canvas |
BOUNDING_BOX = Bounding Box |
SELECTION = Selection |
DETACHED_VOXELS = Detached Voxels |
[DIALOG_MIRROR_WALL_PROPERTIES] |
OPACITY = Opacity |
[DIALOG_WATERMARK_PROPERTIES] |
BACKGROUND_COLOR = Background Color |
TEXT_COLOR = Text Color |
[DIALOG_CAMERA_LIGHT_PROPERTIES] |
INTENSITY = Intensity |
[DIALOG_DIRECTIONAL_LIGHT_PROPERTIES] |
POSITION = Position |
DIFFUSE = Diffuse |
AMBIENT = Ambient |
[MENU_GAMES] |
GAMES = Games |
EDIT_BLOCKS = Edit Blocks |
RESET_BLOCKS = Reset Blocks |
APPLY_BLOCKS = Apply Blocks |
CREATE_COLORS = Create Colors |
NEW_MALE = New Male |
NEW_FEMALE = New Female |
IMPORT_AND_REPLACE = Import and Replace |
EXPORT_HAIR = Export Hair |
EXPORT_SHIRT = Export Shirt |
EXPORT_TROUSERS = Export Trousers |
EXPORT_SHOES = Export Shoes |
[DIALOG_EDIT_BLOCKS] |
ENABLE_ALL = Enable All |
DISABLE_ALL = Disable All |
[MENU_HELP] |
HELP_NOUN = Help |
ABOUT = About |
OPEN_LEARNING_RESOURCES = Open Learning Resources |
GETTING_STARTED = Getting Started |
DOCUMENTATION = Documentation |
HOW-TOS = How-Tos |
GAME_DEVELOPMENT_ARTICLES = Game Development Articles |
FILE_SPECIFICATIONS = File Specifications |
OPEN_FORUM = Open Forum |
FOLLOW_QUBICLE_ON_TWITTER = Follow Qubicle on Twitter |
CHECK_FOR_UPDATES = Check For Updates |
REMOVE_LICENSE = Remove License |
REPORT_A_BUG = Report A Bug |
[DIALOG_RESET] |
KEYBOARD_SHORTCUTS = Keyboard Shortcuts |
TOOL_OPTIONS = Tool Options |
QUICK_ACCESS_BAR = Quick Access Bar |
VIEW_SETTINGS = View Settings |
Copy lines Copy permalink
After you build a pivot table, and add fields, you can rearrange the items in one or more of the fields
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.
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.
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:
- Click on the label that you want to move
- 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.
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:
- Right-click on the label that you want to move
- Click the Move command
- 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.
Type Over Another 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.
- Click on the cell where you want a different label to appear
- Type the name of the label that you want to move
- Press Enter
The existing labels shift down, and the moved label takes its new position. For example, type 'West' in cell A4, over the existing District name, 'Central'
Then, press Enter, to complete the change. West moves to cell A4, and Central moves down to A5.
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 'Est' instead of 'East' in cell A4, when typing over the West label. The East label remains in cell A7, and the West label has been renamed as 'Est'
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. This video shows the steps, and written instructions are below the video.
Here are the steps for moving or adding a field:
NOTE: Be sure type the field name correctly! If you make a typo, you'll change the label for the existing pivot field, instead of adding the new pivot field
![Qubicle move pivot table Qubicle move pivot table](https://forum.minddesk.com/uploads/default/original/1X/4059c2ac0f7aae5e26e023eef7e43581135e3a06.png)
- If the pivot table is in Compact layout, change to Outline or Tabular layout
- Click on the cell where you want a different field to appear
- Type the name of the field that you want to add
- Press Enter
The existing fields shift down, and the added field takes its new position.
In the screen shot below, I'm typing 'Techs' where the District field label is.
When I press Enter, the Techs field is added to the Row area, and District moves to the right.
Download the Sample File
To follow along with this tutorial, download the Move Pivot Table Labels sample file. The zipped file is in xlsx format, and does not contain macros.
Pivot Table Tools
To save time when building, formatting and modifying your pivot tables, use the tools in my Pivot Power Premium add-in. With just a few clicks, you can:
- copy the formatting from one pivot table, and apply it to another pivot table.
- change all the values from Count to Sum
- remove the 'Sum of' from all the headings
and much more!