View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default Pivot Table with lots of columns of source data

Hi,

You need to select the entire table as table array for the pivot table while
you are creating one.
The table will automatically reflect all the columns select by you from the
source data. No need of drag and drop things
--
Thanks
Suleman Peerzade


"hjgc" wrote:

My source data has lots of columns, and I need them all in the pivot table
itself. Is there a quick way of getting them into the pivot table, or do I
need to drag and drop them in one-by-one (which is rather tedious!) ??