| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 87959 | 2008-03-10 03:41:00 | Excel can't drag down formula | Renmoo (66) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 648180 | 2008-03-10 03:41:00 | Quick question here, what has happened to that spot on the bottom right corner of the cell where I can drag down the cell so that the formula stated can be applied for cells below? Attached file: help.JPG (www.imagef1.net.nz) (12 KB) |
Renmoo (66) | ||
| 648181 | 2008-03-10 08:05:00 | good question, its not a protected area of the sheet is it? What version r u on... |
zcc (50) | ||
| 648182 | 2008-03-10 08:33:00 | Not protected. Version 2003. :) |
Renmoo (66) | ||
| 648183 | 2008-03-11 05:28:00 | Well on 2007, there is an option called "Enable fill handle and cell drag and drop", this is exactly your issue... so I hope that option is in 2003. I think its Tools>Options... or something like that. |
zcc (50) | ||
| 648184 | 2008-03-11 07:15:00 | Not sure if this helps but check Tools/Options/ Edit and make sure the tick is in the box "Enable Auto complete for cell values" | Colpol (444) | ||
| 648185 | 2008-03-11 07:48:00 | What if you select the cells you want filled, and go to Edit-Fill Down? | somebody (208) | ||
| 648186 | 2008-03-11 08:25:00 | XL2003 : see Tools > Options > Edit > tick 'Allow cell drag and drop' | andrew93 (249) | ||
| 648187 | 2008-03-11 10:05:00 | Well on 2007, there is an option called "Enable fill handle and cell drag and drop", this is exactly your issue... so I hope that option is in 2003. I think its Tools>Options... or something like that. That works a treat! Thanks :) |
Renmoo (66) | ||
| 1 | |||||