 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / June 2007Pivot 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. 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 > 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.  SignatureDave Peterson 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 > Not and keep it a pivottable. > [quoted text clipped - 10 lines] > > based on the results but I can not do that unless everything is filled in. > > Thanks for your help. Thank you Dave, your macro works wonders for me! Nicole > Not and keep it a pivottable. > [quoted text clipped - 10 lines] > > based on the results but I can not do that unless everything is filled in. > > Thanks for your help. Glad it worked for you. > Thank you Dave, your macro works wonders for me! > [quoted text clipped - 18 lines] > > > > Dave Peterson SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.