Thread: How can I transpose reference cells by Auto-fill?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default How can I transpose reference cells by Auto-fill?
another way
presume yr auto-filled area (=A1,=B1...) is in A2, B2,...
select $A$2:$H$2 area, go to formula bar and insert the formula (this
is an array formula so CTRL+SHIFT+ENTER it)

=TRANSPOSE($A$2:$H$2)
Reply With QuoteReply With Quote