Excel because that cg-tower.com 365 Excel for the net Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel Starter 2010 More...Less

Use Cut, Copy, and also Paste to move or copy cell contents. Or copy particular contents or features from the cells. For example, copy the resulting value of a formula without copying the formula, or copy just the formula.

You are watching: Using the mouse to move or copy cells is called

When you relocate or copy a cell, Excel moves or copies the cell, consisting of formulas and also their resulting values, cabinet formats, and also comments.

You can move cell in Excel by drag and dropping or making use of the Cut and also Paste commands.


*

Move cells by drag and dropping

Select the cell or variety of cells the you want to move or copy.

Point to the border the the selection.

When the tip becomes a relocate pointer

*
, traction the cell or range of cells to another location.

Move cells by making use of Cut and Paste

Select a cell or a cabinet range.

Select Home > Cut

*
or push Ctrl + X.

Select a cell wherein you desire to move the data.

Select Home > Paste

*
or push Ctrl + V.

Copy cells in her worksheet making use of the Copy and Paste commands.

Select the cabinet or selection of cells.

Select Copy or press Ctrl + C.

Select Paste or push Ctrl + V.


Move or copy cells

On the Home tab, in the Clipboard group, do among the following:

To relocate cells, click Cut .

Keyboard shortcut friend can also press Ctrl+X.

To copy cells, click Copy .

Keyboard shortcut friend can additionally press Ctrl+C.

Select the upper-left cell of the paste area.


Tip: To relocate or copy a an option to a various worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the dough area.


On the Home tab, in the Clipboard group, click Paste .

Keyboard shortcut girlfriend can additionally press Ctrl+V.


Notes: 

Excel screens an animated moving border around cells that were reduced or copied. To cancel a relocating border, push Esc.

Excel replaces currently data in the paste area as soon as you cut and paste cells to move them.

To choose specific options as soon as you paste cells, you deserve to click the arrow below Paste , and then click the option that girlfriend want. For example, you have the right to click Paste Special or Picture.

By default, Excel screens the Paste Options switch on the worksheet to provide you special choices when you dough cells, such together Keep resource Formatting. If girlfriend don"t desire to display this button every time that you dough cells, you deserve to turn this option off. Click the File tab, and also then click Options. In the Advanced category, under Cut, Copy, and also Paste, clear the Show Paste options button when content is pasted examine box.


Move or copy cells by using a mouse

By default, drag-and-drop modifying is turn on so the you can use the computer mouse to move and also copy cells.

Do one of the following:

To relocate a cell or variety of cells, allude to the border of the selection. As soon as the reminder becomes a relocate pointer

*
, traction the cabinet or selection of cells to one more location.

To copy a cabinet or variety of cells, host down Ctrl when you allude to the border of the selection. Once the guideline becomes a copy pointer

*
, drag the cell or range of cell to an additional location.


Note: Excel replaces existing data in the dough area once you relocate cells.


When you copy cells, cell references automatically adjust. But, when you move cells, cell references are no adjusted, and also the materials of those cells and of any kind of cells that suggest to them might be displayed as reference errors. In this case, you have actually to change the referrals manually.

If the selected copy area includes hidden cells, rows, or columns, Excel copies them. Friend may need to unhide data temporarily friend don"t desire to encompass when friend copy information.


Insert moved or duplicated cells between existing cells

On the Home tab, in the Clipboard group, do among the following:

To relocate the selection, click Cut .

Keyboard shortcut friend can also press Ctrl+X.

To copy the selection, click Copy .

Keyboard shortcut girlfriend can additionally press Ctrl+C.

Right-click the upper-left cabinet of the dough area, and then click Insert cut Cells or Insert replicated Cells.

Tip To relocate or copy a selection to a different worksheet or workbook, click an additional worksheet tab or switch to another workbook, and then choose the upper-left cell of the dough area.

In the Insert Paste dialog box, click the direction in which you desire to shift the surrounding cells.

Note If girlfriend insert whole rows or columns, the surrounding rows and columns space shifted down and to the left.


Copy visible cells only

If part cells, rows, or columns top top the worksheet are not displayed, you have the alternative of copying every cells or only the visible cells. Because that example, friend can choose to copy only the displayed review data on an outlined worksheet.

On the Home tab, in the Editing group, click Find & Select, and also then click Go to Special.

*

Under Select, click Visible cells only, and then click OK.

On the Home tab, in the Clipboard group, click Copy .

Keyboard shortcut you can additionally press Ctrl+C.

Select the upper-left cabinet of the dough area.


Tip: To relocate or copy a an option to a various worksheet or workbook, click one more worksheet tab or switch to an additional workbook, and also then select the upper-left cell of the paste area.


On the Home tab, in the Clipboard group, click Paste .

Keyboard shortcut friend can likewise press Ctrl+V.

If friend click the arrow below Paste , friend can select from numerous paste alternatives to apply to her selection.

Excel pastes the duplicated data into consecutive rows or columns. If the paste area contains hidden rows or columns, you can have come unhide the dough area to see all of the copied cells.

When you copy or paste surprise or filtered data to one more application or one more instance the Excel, just visible cells space copied.


Prevent copied empty cells from replacing data

On the Home tab, in the Clipboard group, click Copy .

Keyboard shortcut girlfriend can likewise press Ctrl+C.

Select the upper-left cabinet of the paste area.

On the Home tab, in the Clipboard group, click the arrowhead below Paste , and also then click Paste Special.

Select the Skip blanks inspect box.


Move or copy just the components of a cell

Double-click the cabinet that consists of the data the you want to move or copy.

Note by default, you deserve to edit and select cell data straight in the cell by double-clicking it, yet you can additionally edit and also select cabinet data in the formula bar.

On the Home tab, in the Clipboard group, do one of the following:

To relocate the selection, click Cut .

Keyboard shortcut you can also press Ctrl+X.

To copy the selection, click Copy .

Keyboard shortcut girlfriend can additionally press Ctrl+C.

In the cell, click whereby you desire to dough the characters, or double-click an additional cell to move or copy the data.

On the Home tab, in the Clipboard group, click Paste .

Keyboard shortcut girlfriend can additionally press Ctrl+V.

Press ENTER.


Note: When friend double-click a cell or push F2 to modify the active cell, the arrow keys work-related only within that cell. To usage the arrow keys to move to one more cell, an initial press get in to complete your editing changes to the active cell.


Copy cabinet values, cabinet formats, or formulas only

When friend paste duplicated data, you have the right to do any kind of of the following:

Paste only the cell formatting, such as font shade or fill color (and no the contents of the cells).

Convert any type of formulas in the cell to the calculated worths without overwriting the existing formatting.

Paste just the formulas (and no the calculated values).

On the Home tab, in the Clipboard group, click Copy .

Keyboard shortcut friend can additionally press Ctrl+C.

Select the upper-left cabinet of the paste area or the cell whereby you want to dough the value, cabinet format, or formula.

On the Home tab, in the Clipboard group, click the arrow below Paste , and then do one of the following:

To paste values only, click Values.

To dough cell formats only, click Formatting.

To dough formulas only, click Formulas.


Note: If the copied formulas contain loved one cell references, Excel adjusts the references (and the relative components of mixed cell references) in the duplicate formulas. For example, mean that cabinet B8 contains the formula =SUM(B1:B7). If girlfriend copy the formula to cabinet C8, the duplicate formula describes the equivalent cells in the column: =SUM(C1:C7). If the copied formulas contain pure cell references, the references in the duplicate formulas are not changed. If you do not gain the outcomes that friend want, you deserve to also readjust the referrals in the initial formulas to either relative or absolute cell references and then recopy the cells.


Copy cell width settings

When girlfriend paste copied data, the pasted data offers the tower width settings of the target cells. To correct the pillar widths so that they enhance the resource cells, follow these steps.

On the Home tab, in the Clipboard group, do among the following:

To move cells, click Cut .

Keyboard shortcut you can likewise press Ctrl+X.

To copy cells, click Copy .

Keyboard shortcut friend can also press Ctrl+C.

Select the upper-left cabinet of the paste area.


Tip: To relocate or copy a choice to a various worksheet or workbook, click another worksheet tab or switch to one more workbook, and also then pick the upper-left cabinet of the dough area.


On the Home tab, in the Clipboard group, click the arrowhead under Paste , and also then click Keep source Column Widths.

See more: Can You Eat Shrimp Cocktail While Pregnant, Is It Safe Or Not


Need more help?

You can always ask an skilled in the Excel tech Community or gain cg-tower.com in the answer community.


*
*
*

Need much more help?


Expand your skills
Explore Training
Get brand-new features first
Join cg-tower.com Insiders

Was this information helpful?


YesNo
Thank you! Any much more feedback? (The much more you tell united state the more we have the right to help.)Can you help us improve? (The much more you tell us the an ext we have the right to help.)
What affected your experience?
Resolved my issue
Clear instructions
Easy come follow
No jargon
Pictures helped
Other
Didn't match my screen
Incorrect instructions
Too technical
Not sufficient information
Not enough pictures
Other
Any additional feedback? (Optional)
Submit feedback

Thank you for your feedback!


×
What's new
cg-tower.com Store
Education
Enterprise
Developer
Company
English (United States) © cg-tower.com 2021