Home Menu

Menu


ExcelBanter » Excel Newsgroups » New Users to Excel > Inserting rows and having the formula follow
 
 
LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
workofiction
 
Posts: n/a
Default Inserting rows and having the formula follow
I have the formula =SUM(I2:I190/F2:F190) which works wonderfully. Only
problem is that when I go to insert a new row, the formula won't follow down
that column without draggin it from the cell above... any way to do this
automatically?
Thanks in Advance!
Reply With QuoteReply With Quote
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Threaded Mode Threaded Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement