Display array (like Tranpose) but without transposing

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Is there a display functionality that would allow one to show the
contents of an array like in the transpose function but without
transposing?

Thanks!
 
Hi
try the following:
- select cells B1:B10
- enter =A1:A10
- hit CTRL+SHIFT+eNTER
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LINEST multiple known_x's separated arrays 5
transposing across different worksheets 3
transpose array of non-adjacent cells 3
Reverse Transpose? 4
TRANSPOSE results in zero values for blank cells 2
TRANSPOSE results in zero values for blank cells 4
Transposing Array 4
Transpose a table 2

Back
Top