vba-excel-training - Absoluting values

Hi Karen, Thank you for your post, its good to hear from you, there are a couple of ways of answering your post;
1. To Absolute a single cell - select the cell reference in the formula and press the F4 key (Function 4) this will append the $ signs to the cell reference making it absolute. now copying this formula using the Fill handle, will "pin" that cell reference in the formula to the absolute cell.
2. To apply absolute to a range of cells (a block) I think it would be easier to Name the range, to do this select the cells and then click in the Name Box (on the left hand end of the formula bar) type in a meaningful name and press the enter key. This has named the cells and the name can be used in a formula ie =sum(Data2007) this will total all the cells in the named range Data2007, naming other ranges will allow you to create formulas of named ranges which will be absolute across the entire workbook. Hope that helps, Pete