Home |
Search |
Today's Posts |
|
#1
![]()
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) |