How can I activate the pivot table list field with the keyboard?


Does anybody know which is the shortcut for activating the pivot table list field to check or uncheck fields with space bar.

Thanks for your time

-------------Problems Reply------------

To view the field list you need to click on any of the cell (data cell) within the pivot table and then use the key board shortcut alt+jt+L

To add or remove the fields to the report under the pivot table field list, you have to click on any of the field and use the space bar.

For more help regards to pivot table you may also post in the below forum:

Thank you very much, Deepa. I really appreciate your help.

Hi Deepa,

Whats JT stand for in your keyboard shortcut.


Category:Office Views:1 Time:2012-07-24

Related post

  • Can a pivot table calculated field's formula reference the row value of another field in the same pivot table? 2014-04-18

    I would like to be able to use the following formula in a pivot table calculated field: =IF('Cost Type' = "Internal Labor Cost", 'Jan Delta' / 78, 0) However, the result is always zero. Is there any way to reference the row value of another pivot tab

  • Excel 2013 - pivot table calculated fields - referring to other dimensions in calc 2014-08-15

    I'm struggling to find much useful documentation on Excel 2013 pivot table calculated fields. My pivot table is fairly simple. I have a 'Company' dimensions as rows (e.g. 'A', 'B' etc) and calendar weeks as columns ('1' --> '52'). The value in the

  • Pivot Table no Field List 2012-09-24

    Yesterday I managed to make a pivot table. Today, when I do it, I select the area with everything, but no field values show up on the next page. Yesterday I dragged the fields to the pivot table and it all looked good. I don't really know how to set

  • Pivot Table Calculated Field: % of Subtotal 2014-05-04

    I've created the above pivot table and no matter what I do I'm unable to create a calculated field in column D of the pivot table. In cell D5 I am trying to get the percentage: C5/C8, In cell D6 I'm trying to get the percentage: C6/C8, etc. I can cal

  • Excel pivot table calculated field total returns unexpected value 2009-11-16

    I have an Excel spreadsheet which has a pivot table on it. The data itself is quite simple, Number of Units and a Discount (percentage from 0 to 100), pivoted on date across the top and customer down the left hand side. Those numbers are straight fro

  • How to reference cells in a Pivot Table using Field values? 2010-08-31

    I have a pivot table created from 3 fields where (for example): field1 values are: "1", "3", "5" field2 values are: "A", "B", "C" field3 values are: "X", "Y", "Z" So given a pivot table PT1 I want to reference a cell within the table in a similar way

  • Pivot table - Calculated field 2012-01-23

    Is it possible to create a pivot table that sums all fees and then create a calculated field that sums the fees based on a another fields requirements? For example: =IF('Type'="Associations",Sum(Revenue)) - I can't seem to get the 2 to work in the sa

  • Pivot table caculated field 2012-02-17

    I have a pivot table where I'm grouping by a column that would give either a yes/no response. For the yes group, i need to use the Max function to give a result; for the no, I need a sum. Is that something I can do with a calculated field? If so, how

  • Excel 2010 - Retain Pivot Table Value Field Conditional Formatting 2012-07-07

    I have an Excel 2010 pivot table with several value fields to conditional format. I want to the conditional format to persist after the user drags the field out of the values section and then back into the values section. When I do this, the confidit

  • #VALUE! error in a Pivot Table Calc Field 2013-02-12

    Hi I am using IFERROR in a Calc Filed on a Pivot table. However I get #VALUE! errors The formula works ok on a spread sheet, it is just when I add it to the Calc Field that the error comes up =iferror(A/((B/5)*C),"") The error comes up as C is someti

  • Excel 2010 pivot table row field returns blank when source field larger than 255 characters 2013-02-24

    In the past, when you included a text field larger than 255 characters in the row labels section of a pivot table, Excel would truncate the field to the first 255 characters. Now, in 2010, I find it won't display the text at all. Is there some settin

  • Pivot Table Calculated Field results in error when data updates 2013-03-17

    Has anyone any suggestion as to why a pivot table returns the Name error in calculated fields after additional columns are added to a database. To recreate the problem: a) Create a simple database - Field names: Product, Quantity and Price; b) Insert

  • Pivot table Group Field ignores start date if before start of data 2013-04-12

    I have a Pivot table and am using "group field" to group dates in the table rows into weeks. The data set begins at the beginning of a month but part way through a week. Setting the Group Field to the Monday before and counting 7 days from there does

  • Pivot table calculated field, how to get a % weighting by subtotal grouping? 2013-12-04

    In a pivot table I know you can get a % of a row to get a weighting as a % of 100% on that line, but is there a way to do that same calc vertically? For example if you organize data by Sales people, but want to do an individual weighting of the produ

  • Pivot Table Total Fields 2013-12-16

    I have a simple pivot table and need to put in a total field to sum the values in a field. I have tried to Auto Calc function but I can only use count. The Sum and all other options are greyed out and I can use them. Below is an example of my date. A

  • Pivot Table hide fields not remove fields in Excel 2010 2013-12-20

    in Excel 2003 one can hide a complete field and not remove it. i cannot find out how one does this in 2010. i have a simple matrix of data. column A has date periods 1month, 2month, 3month and so on column B has order numbers to order the data so 1,2


    I have a sample table like: Client Product Price Client1 P3_New $206 Client2 P3_New $593 Client3 P3_New $362 Client4 P3_Expired $523 Client5 P3_Old $758 Client6 P1_Old $473 Client7 P2_New $861 Client8 P2_Old $172 Client9 P2_New $816 Client10 P3_Expir

  • select multiple items in a pivot table page field vba (without looping through each pivot item) 2014-02-17

    Hi, I have a large pivot table with a page field with hundreds of entries. I would like to select multiple items via vba without having to loop through each Pivot Item. I would like to deselect all items then select the items I want. All the code I h

  • excel pivot table calculated field 2014-03-04

    If I have a table with col1 that has number values. Then in a pivot table I would like to count the number of rows that the value is greater than 5. I tried creating a calculated field like this =COUNTIF( Col1 ,">5") But this causes an error. any

Copyright (C), All Rights Reserved.

processed in 0.191 (s). 11 q(s)