Thread: how can i fill data in blank cells after copying a pivot report?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default how can i fill data in blank cells after copying a pivot report?
You can use Edit: Go To: Fill Blanks to paste a formula. Here's a step by
step.

http://www.kan.org/tips/excel_fill_blanks.php

--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Antz" wrote:

I need to fill data in blank cells after copying a pivot report as values.
At present this is being done by copying individual cell values and pasting
it on the blank cells below.
Reply With QuoteReply With Quote