Dan Waters
dwaters at usinternet.com
Sat Oct 7 15:43:56 CDT 2006
Hi Rocky, Yes! And it's easy. Just put a $ in front of the column letter in the spreadsheet formula. Create your formula, copy, then paste into the cells where you want the formula to be. When you look at the formula in those cells, you'll see that the column reference has not changed. You can do the same with the row references too. In fact, you can get pretty clever by combining column and row references that do change and that don't change. All the best, Dan Waters -----Original Message----- Subject: [AccessD] OT: Excel Question - Lock a Formula Dear List: I have a formula in a cell in Column E that averages the next 12 cells in the row (=(F4-R4)/R4). When I insert a column after this formula, it changes the formula to =(G4-S4)/S4. I would like the formulas in column E to not change. Everything else can. Is there a way to 'lock' the formulas in just this column? MTIA Rocky -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 10/6/2006 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com