View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown[_6_] Gary Brown[_6_] is offline
external usenet poster
 
Posts: 126
Default Is there a difference between CTRL+D and CTRL+" (quotation marks)

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.