View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] lrbtav@gmail.com is offline
external usenet poster
 
Posts: 1
Default Copy without reference cells

Hi, I have a few hundred of formulas such as this throughout my excel
file: =IF("L2"1,L2,"")

I need to copy/paste these formulas down about 50 rows, Without the
formulas correcting their cell references. Is this possible?