| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Fill In
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Fill In
Thank you! The macro on Debra Dalgleish's site was exactly what I needed. I
also needed to copy the pivot table to a new worksheet, then I could select the left column and run the macro to fill in the missing cells. Such a time saver! Nicole "Dave Peterson" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Fill In
Thank you Dave, your macro works wonders for me!
Nicole "Dave Peterson" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Fill In
Glad it worked for you.
Ursina wrote: Thank you Dave, your macro works wonders for me! Nicole "Dave Peterson" wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Row in Pivot without changing the order of the columns | Excel Discussion (Misc queries) | |||
| pivot clears cell fill color | Excel Discussion (Misc queries) | |||
| Pivot tables - Fill In All Rows | Excel Discussion (Misc queries) | |||
| How do I fill in pivot table blanks? | Excel Worksheet Functions | |||
| How do I get a column to "auto fill" in a pivot table? | Excel Discussion (Misc queries) | |||
Hybrid Mode
