View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
GARYWC GARYWC is offline
external usenet poster
 
Posts: 80
Default Concatenating formulas

When I insert a new row at the top of my spreadsheet, the existing cells move down one row. I then enter the appropriate data in the new row's cells.

The INDIRECT function ensures that the formulas always refer to the cell in the top row of my spreadsheet.