| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table colums selection
I have a worksheet with columns of data I need to select and those I don't
need to select. Since the are not sequential I use the CTRL key to select those I need. So column c,f,h,m,n r as an example I get the warning indicating invalid range. Do the ranges always have to be next to each other? (I do hope not!!!) -- Bill |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Pivot table colums selection
Yes, a list used as the source for a pivot table must be in adjacent
columns. Bill wrote: I have a worksheet with columns of data I need to select and those I don't need to select. Since the are not sequential I use the CTRL key to select those I need. So column c,f,h,m,n r as an example I get the warning indicating invalid range. Do the ranges always have to be next to each other? (I do hope not!!!) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| how to remove old selection values in the pivot table | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Linear Mode
