• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Format (Customized/Optional) visualization of data in cells

Uzzal

Member
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?
upload_2014-10-23_17-32-35.png
 
@Uzzal

The feature is available in Excel 2010+. For you you have to get a walk around of Copy Paste and some other steps. If you like we can share that.

Regards,
 
@Uzzal

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.

C1.JPG

EG Pivot data Copy Pasted. Select the Range D2:D13. Hit F5 Now. This will open below box.

C2.JPG
Select Special. This will open Below box.
C3.JPG

Select Blanks hit OK.

Now all the blank cells are highlighted. Now put the formula as shown below.
=D2 and press Ctrl+Enter.
 
Contd. from prev.

C4.JPG

Here it is not showing cells are selected but in actual all the blanks cells in that range are selected.

Repeat the same for Next column.

Regards,
 
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)
 
@Uzzal

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.

Regards,
 
Sounds you are correct Somendra.
I have just uploaded a new thread for this in VBA room.
Please stay with.
 
Back
Top