Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drap copy without increasing the value
Can someone please let me know if there is a way to copy cell contents with
the cell drag and drop option without it increasing the value, but copy what was in the contents i.e. "F2" in fields A1 through A12. and not F2 in field A1 F3 in filed A2. PLease hlep. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drap copy without increasing the value
Dragging a field like F2 causes Excel to assume you want F3 in the next cell
and F4 in the following cell. Hold Ctrl while dragging and Excel will not change the F2 to F3 etc. The same applies to dates. If you have a numeric 1 in a cell and drag it, Excel will not change it unless you press Ctrl while dragging. Time for a book on elementry Excel, perhaps? Tyro "jchandler0614" wrote in message ... Can someone please let me know if there is a way to copy cell contents with the cell drag and drop option without it increasing the value, but copy what was in the contents i.e. "F2" in fields A1 through A12. and not F2 in field A1 F3 in filed A2. PLease hlep. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drap copy without increasing the value
$ signs are your friends
$F$2 is absolute column and row. $F2 is absolute column and relative row. F$2 is absolute row and relative column. Anything preceded by a $ sign will not change when dragged down or across. See more on this in Help. Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 15:39:01 -0800, jchandler0614 wrote: Can someone please let me know if there is a way to copy cell contents with the cell drag and drop option without it increasing the value, but copy what was in the contents i.e. "F2" in fields A1 through A12. and not F2 in field A1 F3 in filed A2. PLease hlep. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a formula with the cell increasing by increments? | Excel Discussion (Misc queries) | |||
Increasing font? | Excel Worksheet Functions | |||
How do I copy a formula with increasing worksheet numbers | Excel Discussion (Misc queries) | |||
how can I copy dates, etc. without them automatically increasing | Excel Discussion (Misc queries) | |||
Increasing M in M/D/Y | Excel Discussion (Misc queries) |