key board short cut for copying formula from one cell to another

  • Thread starter Thread starter mario
  • Start date Start date
M

mario

Lets there is a formual in cell lets say "c1".,

If I want to copy the formula from c1 to c2, I place the
cursor (using mouse) on the bottom right corner fo c1 and
drag it to c2.

Is there a key board short cut of doing the above.

Pls help,.,

thanks
 
Mario, select C1 and C2, then Ctrl+D. If C1 is the active cell, press
Shift+Down Arrow to highlight cells below, then Ctrl+D to copy the formula.

To copy to the right rather than down, Ctrl+R.
 
Might add, that holding
<Shift>
While hitting (holding)
<DownArrow>
Will select a range of cells down the column, which,
When hitting
<Enter>
Will copy to the entire selected range!
 
Back
Top