Thread: click and drag a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe@Phoenix Joe@Phoenix is offline
external usenet poster
  
Posts: 8
Default click and drag a cell
=A1+B2

if i click and drag it into more cells it changes to =A2+B3 and in the next
one =A3+B4 and so on.

how do i stop it from doing that? i want it to show =A1+B2 in every cell.
Reply With QuoteReply With Quote