| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i fill data in blank cells after copying a pivot report?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NEED TO FILL BLANK CELLS IN DATA WITH TEXT STRING | Excel Worksheet Functions | |||
| Fill blank cells with cells above data | Excel Worksheet Functions | |||
| shifting of data to fill into blank cells | Excel Discussion (Misc queries) | |||
| How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Linear Mode
