Thread: Pivot Fill In
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Pivot Fill In

Not and keep it a pivottable.

You could convert the PT to values (or copy|paste special|values to a new sheet)
and then fill the cells on that copy.

See Debra Dalgleish's site for tips to fill those empty cells:
http://contextures.com/xlDataEntry02.html

Richard wrote:

When using pivot tables, Excel only fills the first cell in a particular
column for each section or category of data. Is there a way to get the pivot
table to fill all the data elements to have a completely filled in
spreadsheet? I would like to format or even possibly complete another pivot
based on the results but I can not do that unless everything is filled in.
Thanks for your help.


--

Dave Peterson