Thread: How can I transpose reference cells by Auto-fill?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CKK CKK is offline
external usenet poster
  
Posts: 4
Default How can I transpose reference cells by Auto-fill?
Thx! both answers is work
--
CKKwok


"Jarek Kujawa" wrote:

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