Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to copy a cell's data to the 4 cells below it.

ex: If I have 'apple', I need


Please suggest to me a short cut that will do this.

share|improve this question

migrated from Mar 18 '11 at 9:07

This question came from our site for professional and enthusiast programmers.

select 4 cells bellow and press Ctrl-D... – bensiu Mar 18 '11 at 5:10
if you are averse to dragging the mouse there is very little that can be done , probably you could write a macro – Shekhar Mar 18 '11 at 9:14
@bensiu +1 never knew that one. Plus selecting the cell above the four, probably was understood. – datatoo Mar 25 '11 at 23:02

Or you can just click+drag the lower-right corner of the cell, 4 cells down, the old-fashioned way.

share|improve this answer

Select "apple", hold shift, push down arrow a bunch, push ctrl-d.

If you want the same amount of rows of "apples" as there are in a neighboring column: click on the apple, shift+right arrow, ctrl + shift + down arrow (now two columns are highlighted), shift + left arrow (now just the empty column with apple on top is highlighted), ctrl+d

share|improve this answer

Why can't you just CTRL+C the apple cell and select what ever cells you want and CTRL+V ? This should be the faster method, no?

You can select other cells by:

  • clicking the target cell
  • click on a starting cell and drag to get a range
  • ctrl and click to add to selected cells.

Use any of the above combination and you can select any cell you want.

share|improve this answer

You must log in to answer this question.