ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I select multiple items in an Excel 2003 Pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/221353-how-do-i-select-multiple-items-excel-2003-pivot-table.html)

Kevin

How do I select multiple items in an Excel 2003 Pivot table
 
I have a field that is "outside" the data area and I only want to select
certain items to view. If that field box is "inside" the data area, then it
lets me do it. Is there a trick to select multiple items like in Excel 2007?

FSt1

How do I select multiple items in an Excel 2003 Pivot table
 
hi
not sure what you mean by "outside the data area" but to select multiple
areas on a sheet, hold the Ctrl key down while selecting with the mouse. but
in 2007, due to the light color highlight, it's hard to see just what has
been selected.

regards
FSt1

"Kevin" wrote:

I have a field that is "outside" the data area and I only want to select
certain items to view. If that field box is "inside" the data area, then it
lets me do it. Is there a trick to select multiple items like in Excel 2007?



All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com