How do you paste into Excel into multiple cells?

Copying cells and pasting in multiple cells is very easy in Microsoft Excel. We can copy a single cell and select the target range of cells to paste. We can do this manually, using

How do you paste into Excel into multiple cells?
Copy Same Value in Multiple Cells

Copying cells and pasting in multiple cells is very easy in Microsoft Excel. We can copy a single cell and select the target range of cells to paste. We can do this manually, using built in commands available in excel or we can also do it using shortcut keys.

  • Copy Same Value in Multiple Cells
  • Copy using built in commands
  • Copy Using Standard Shortcut Keys in Excel
  • Copy using Auto fill Method

Copy Same Value in Multiple Cells

You can enter same value in multiple cells simultaneously, it is very useful to fill range of cells at the same time.

  • Select the range of Cells
  • And enter required text to have in the Cells (this will be keyed in active cell)
  • Press Ctrl+ Enter keys to repeat the same text in multiple cells in Excel
Copy Same Value in Multiple Cells

Select the Range

Copy Same Value in Multiple Cells -Select

Enter Cell Value

 Copy Same Value in Multiple Cells - Enter Text

Press Ctrl+Enter

Copy Same Value in Multiple Cells - Enter Shortcut Key

Copy using built in commands

  • Select the Cell which you would like to copy
  • Right click on it and select Copy from command from Cells contextual menu (or, in Home Tab in Ribbon menu)
  • Now select the range of cells which would like to repeat the same value
  • Again, right click on it and select Paste command from contextual menu
  • Press ESC key to disable copy cut mode
 Copy using built in commands

Copy Using Standard Shortcut Keys in Excel

Copy Using Standard Shortcut Keys in Excel
  • Select the cell which would like to copy
  • PressCtrl+ Ckeys to copy the Cell
  • Select multiple cells, which is your target range of cells
  • Now pressCtrl+ Vkeys to paste

Copy using Auto fill Method

If you want to copy the cell into the cells which are adjacent to the source cell. Then you can use this method.

  • Select the Cell which you would like to duplicate
  • Hover your mouse cursor at the bottom right corner of the cell
  • You can see a small plus symbol
  • Hold that with your mouse and drag down on to the destination/target range
Copy using Auto fill Method

PreviousNext

Share This Story, Choose Your Platform!

3 Comments

  1. VENKATESAN C May 24, 2022 at 9:39 am - Reply

I want to copy two Cells, and at the same time in different value. want to paste one by one for two different Cell. please how to do?

  1. VENKATESAN C May 24, 2022 at 9:45 am - Reply

once copied two different cells in different value. how to past one by one to two different cell?
Example: At the same time copied A and B in two different cell after i want to paste first A one cell second time paste B once cell.

  • PNRao June 20, 2022 at 12:30 pm - Reply

You cant do this using commands. You can use VBA to select the cells to store into tow different variables and paste into required Cells.

Leave A Comment Cancel replyComment

Save my name, email, and website in this browser for the next time I comment.

Video liên quan