Hi, for same data in more then one cell, it visualize the data only in the first cell showing other cells empty,but when mouse is pointed there it visualize the data of that cell, How to do it ? any help/ tips please?
Select the Entire Pivot Table, Copy, Select a Position to Paste (Paste Special - Values).
Now select the range where you want to repeat labels. Hit F5, Click Special. Now Select Blanks, Click Ok. So You will see all the blank cells has got selected in that column. Now Hit F2, type =A1 (A1 is the cell ref. of the cell where is the first data) . Now hit Ctrl+Enter. That's it.
See the image below.
EG Pivot data Copy Pasted. Select the Range D2:D13. Hit F5 Now. This will open below box.
Select Special. This will open Below box.
Select Blanks hit OK.
Now all the blank cells are highlighted. Now put the formula as shown below.
=D2 and press Ctrl+Enter.
Thanks Somendra,
It was very interesting to learn such a good technique in excel.I am so excited that for the first time some one is helping me to learn excel over net.
Is it possible to keep those data invisible in the blank cells & it will be visualized only when the mouse pointer will be there ? (like the way we use to see the comments of the cells)
What you are saying is not possible directly in Excel. But may be some clever VBA code can do that. Will do some practical over it and if succeeded will post something.
Why not you start a new thread with the ref. to this thread and ask for a freah requirement. There are so many expert VBA programmer on this site, may be somebody will come up with something.