Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
And if there is a difference, what is it?
They both appear to copy the data from the cell above the selected cell. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ctrl+D is a relative copy
Ctrl+" is an absolute copy Example: Assume... A1 = +B1 B1 = "Hello" if you put your cursor in A2 and select Ctrl+D, A2 will be =+B2 if you put your cursor in A2 and select Ctrl+", A2 will be =+B1 -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "AKMMS" wrote: And if there is a difference, what is it? They both appear to copy the data from the cell above the selected cell. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If D1 has a non-formula (text, number, date, TRUE/FALSE) and I use either
CTRL+D or CTRL+" in cell D2 I will get a copy of the value in D1 If D1 has a formula -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme, the two give a different answer If D1 has =A1, the in D1 the use of CTRL+D give =A2 which is what I would get by dragging or copying D1 to D2 But CTRL+" will give =A1 ; so it gives an exact copy of what is in D1 without updating the cell references best wishes "AKMMS" wrote in message ... And if there is a difference, what is it? They both appear to copy the data from the cell above the selected cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with | Excel Discussion (Misc queries) | |||
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) |