| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ctrl D with formulas
When I put a formula in B87 [=SUMIF(B5:B81,"3A",H5:H81)*24] and then select
B87:B94 and use the Ctrl D function, it will copy the formula but the range will change by 1 line each time so that B88 will start with the range (B6:B82, "3A", H6:H82), etc. By the time I reach B94, the formula range is completely off and I have to go into each formula and manually change the range back to what it should be. What am I doing wrong? I need to freeze the formula so that it keeps the same range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
| use CTRL key inside a macro IE CTRL + ; | Excel Worksheet Functions | |||
| Anyone having Ctrl+C / Ctrl+V problems in E2007? | Excel Discussion (Misc queries) | |||
| How to forbid ctrl+c and ctrl+X in sheet? | Setting up and Configuration of Excel | |||
| Does Ctrl + F works in protected file with formulas? | Excel Worksheet Functions | |||
Threaded Mode
