Thread: How do I keep letters the same and change the # for drag formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ASST ASST is offline
external usenet poster
  
Posts: 1
Default How do I keep letters the same and change the # for drag formula
I want to have the columns do the following
A1 b1
A2 b2
A3 b3

When I drag/drop they go
A1 A2
B1 b2
C1 c2
What formula can I use to reorientate my data?
Reply With QuoteReply With Quote