View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zhi Sheng Zhi Sheng is offline
external usenet poster
 
Posts: 13
Default How do I "paste link", and "transpose" at the same time?

I'm using Excel 2003.
In "sheet 1", I have:
1
2
3
I want to paste link of these 3 cells into "sheet 2", and display them like:
1 2 3

I know I can use "transpose" array formula, but it's not "safe" when other
users of the spreadsheet are not familiar with array formula.
--
====================
ask and you shall be answered