How to Display List in a single row

Originally Posted by p_dhoke

Hi,
I want to display the list of data to be displayed as my cursor moves down or up.
example
A
B
C
D
E


I want to display the data according to my cursor movement over them in a single cell. Is it possible in excel.

Pavan

Hi,

whilst it is possible to detect mouse movement over an autoshape it is not possible to detect movement over a cell, only cell selection.

Thus, you would need to use a transparent shape to detect movement and perform some action, but it might be difficult to tie that action to a scroll movement rather than the simple location of another shape.

What you probably will find easier to use is a dropdown or combobox.

Hope this helps.
---

Hi,

Well have you tried to use the concatenate function ...?
=concatenate(a1,a2,a3,....)

have you tried using

=A1&A2&A3&A4...&A399&A400...

Concatenate has a maximum limit of 30 references --but, these don't necessarily have to be cell references..

You could, in cell b1 for example, have

=concatenate(a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,...,a30)

Then in b2 have

=concatenate(a31,a32,a33,a34,a35,...,a60)

Then in a nth cell have

=concatenate(b1,b2,b3,...,b29,b30)

So you could literally have 900 references nested into 30. You could then expand it further to be 30*30*30 (27,000).

For example, in c1, you could have =concatenate(n1,n2,n3,...,n30) where each "n" represents 900 references.

I know, that's crazy talk, but it would work up until the maximum limit of text per cell was reached (32,767 characters in Office 2003).

Originally Posted by p_dhoke

Hi,
i have tried =concatenate(a1,a2,a3) it is ok if list is small but if list is long than this wont help ? kindly suggest other solution

Hi

if you have list in col A starting from cell A1, put in B1 the same value which is in A1.
then in B2 put =B1&", "&A2 and drag it down in col B.
last cell in col B will have the complete list.

here is attached file.

star... you make things too simple.

Sometimes we over-think things a bit. It can't just be me!

Thx

Originally Posted by pjoaquin

star... you make things too simple.

Sometimes we over-think things a bit. It can't just be me!

Thx

no problem.

sometimes one thinks a solution in one way and other in other way.

thank you for the feedback.