View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TKS_Mark TKS_Mark is offline
external usenet poster
 
Posts: 68
Default Overwrite All Cells in Column

Excel 2007 has an excellent feature that makes the formulas automatically
jump into new rows when you insert them into a "table". But sometimes these
formulas stop filling in automatically, like when you find and replace all
within a worksheet. I have 20 sheets per file x 25 columns x 15 files to
turn this automatic function back on. It sure would be great if I could
select several columns and tell them to go back to automatically filling new
rows w/ new data.

Is there already such a thing?

Thanks.