Show In this article, we will learn how we can copy and paste in adjacent cells quickly in Microsoft Excel 2010. Let’s take an example to understand how we can copy and paste in the adjacent cells quickly. We have data in range A1:C11 where Column A contains Name, column B contains Score (1st Day), and column C contains score 2nd day.
In column D, we want to return the total score, then we need to copy paste the formula with the fast option. We will have to follow below given steps:-
If you want to copy and paste the content in the range side of the range, you need to follow below given steps:-
This is the way we can fast copy and paste the adjacent cells in Microsoft Excel. This tutorial will demonstrate how to copy and paste multiple cells in Excel and Google Sheets. Copy Adjacent CellsFill HandleThere are a number of ways that a range of cells can be copied and pasted in Excel. The simplest way to copy multiple or a range of cells across from one column or row to another is use the mouse to drag the values across from one column or row to the next.
‘ This method works well for both copying of cells from column across to an adjacent column on the right, or from a row down to the next row. Quick Menu
Note that the source cells have small moving lines around them indicating that the information is ready to paste.
Copy Non-Adjacent Cells
Copy Entire Columns and/or Rows
A new column is inserted before the column you selected. This new column will contain the copied cells. Note: if you have selected a blank column (i.e., no data in any of the cells), you can just press ENTER on the keyboard or select Paste from the quick menu to paste the copied data into the existing column. You copy a row in the same way. Click in the row header of the row you wish to copy to select the row, and then right-click and select Copy. Right-click on the destination row header and to insert a row with the copied data, click Insert Copied Cells, or click Paste to paste the data into an existing row. Copy FormulasIf you have a cell with a formula in it, and you wish to use that formula in adjacent, or non-adjacent cells, you can copy the formula in the same way as you would copy cells above.
Small moving lines indicate that the cell has been copied.
As you look down at the copied formula, you will notice that the formula automatically changes according to the row and column you are copying down or across to. Note: You can also copy and paste an exact formula so that the row and column information don’t change. Copy Cell Data or FormulaIn the picture above, the formatting from cell E3 was pasted into cells E4:E7 along with the formula. The same thing happens when you copy cell data without a formula. To prevent this from happening, select paste options to just paste the formulas without the format.
OR In the Ribbon, select Home > Clipboard > Paste > Paste Formulas. This pastes the formulas into the selected cells without any formatting. Copy a Formula to Adjacent CellsYou can also drag the formula down to the adjacent cells by using the fill handle. Note that this method will also copy the formatting down to the adjacent cells along with the formula. If required, it is also possible to use the Paste Options to paste the formula as text. Copy-Paste Multiple Cells in Google SheetsCopying and pasting in Google Sheets works in much the same way as it does in Excel.
You may get a message that you need to install an extension to use Edit > Paste. You can either dismiss the information message
and use CTRL + V to paste the cell data, or you can install the extension into your browser to enable you to use Edit > Paste on the menu.
Adjacent CellsTo copy the cell data across to adjacent cells using the mouse, highlight the cells containing the data, and then, drag the mouse pointer across to the desired destination cells. Non-Adjacent CellsSelecting non-adjacent cell ranges in Google Sheets works the same as in Excel. Select the first range then, holding down the CTRL key, select the second range. Then copy both ranges using CTRL + C or in the Menu, select Edit > Copy. Select the destination location and the press CTRL + V or, in the Menu, select Edit > Paste. Copy Entire Columns and/or Rows
The copied data is pasted into the new column. Copying an entire row works in the same way; just click the row header instead of the column header! For more information on copying and pasting in Excel and Google Sheets, see:
|