Thread: Inserting Lines or Copying lines with formulas but without data
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Montrose77 Montrose77 is offline
external usenet poster
  
Posts: 1
Default Inserting Lines or Copying lines with formulas but without data

In situations such as that, I find it useful to create a blank row (or
column, as the case may be) that has the formulas, but no data. Then
every time I add a new row I copy from that one.


--
Montrose77
------------------------------------------------------------------------
Montrose77's Profile: http://www.excelforum.com/member.php...o&userid=18191
View this thread: http://www.excelforum.com/showthread...hreadid=573072

Reply With QuoteReply With Quote