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'm trying to copy a block of cells, but instead of shifting down the rest of the rows, it overwrites them

How do we copy and paste a set of cells and shift the rest so nothing is lost?

share|improve this question
up vote 9 down vote accepted

Instead of clicking "Paste", right-click or Ctrl click and select "Insert Copied Cells" or "Insert...", depending on your version of Excel.

insert copied cells

This will give you an option to shift cells right or down.

shift cells

If you cut cells, the context menu will have the option to "Insert Cut Cells" instead. Microsoft has a support article that describes these steps and other copy/paste options.

In the Mac Version it's:

enter image description here

enter image description here

share|improve this answer
    
No Idea how I missed that the first time I looked. Extra Note: in mac version it's Insert... – Iancovici Sep 27 '13 at 13:25
    
@echad Good point; I only have access to Windows at the moment, but I remembered it being the same or similar on a Mac. I updated the answer with a brief note to that effect. – John Bensin Sep 27 '13 at 13:35
    
@echad Thanks for the new screenshot. It would have been a while before I could get access to a Mac version of Excel. – John Bensin Sep 27 '13 at 13:45
1  
FYI, the cells have to be in the same spreadsheet for this to work, else it will just replace them and you won't get the insert option. – user321224 May 7 '14 at 20:43
2  
To add Eduardo's explanation: to paste from external source workaround, just paste it in another cell or sheet first, then copy-and-paste it again. – suud Jun 3 '14 at 4:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .