Thread: How do I keep my cell reference from moving even when I use the $.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mat_W Mat_W is offline
external usenet poster
  
Posts: 1
Default How do I keep my cell reference from moving even when I use the $.
Cell on sheet 2 has formula where if false displays a cell value on sheet 1,
i have the $ lock symbols placed but when I insert columns on sheet 1 the
reference on sheet 2 increments by how ever many columns I insert. how can I
keep this from happening?????
Reply With QuoteReply With Quote