Excel because that aramuseum.org 365 Excel for the internet Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel Starter 2010 More...Less

Use Cut, Copy, and Paste to move or copy cell contents. Or copy particular contents or characteristics from the cells. Because that example, copy the resulting value of a formula without copying the formula, or copy only the formula.

You are watching: The copy button copies the contents and format

When you move or copy a cell, Excel move or copies the cell, including formulas and their resulting values, cell formats, and comments.

You have the right to move cell in Excel through drag and dropping or using the Cut and Paste commands.


*

Move cell by drag and also dropping

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

Point to the border of the selection.

When the guideline becomes a relocate pointer

*
, traction the cabinet or variety of cells to an additional location.

Move cells by utilizing Cut and also Paste

Select a cabinet or a cell range.

Select Home > Cut

*
or press Ctrl + X.

Select a cell wherein you desire to move the data.

Select Home > Paste

*
or press Ctrl + V.

Copy cells in her worksheet using the Copy and also Paste commands.

Select the cabinet or range of cells.

Select Copy or push Ctrl + C.

Select Paste or press Ctrl + V.


Move or copy cells

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

To move cells, click Cut .

Keyboard shortcut girlfriend can also press Ctrl+X.

To copy cells, click Copy .

Keyboard shortcut girlfriend can also press Ctrl+C.

Select the upper-left cabinet of the paste area.


Tip: To move or copy a an option to a various worksheet or workbook, click an additional worksheet tab or switch to another workbook, and also then choose the upper-left cabinet of the paste area.


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

Keyboard shortcut girlfriend can also press Ctrl+V.


Notes: 

Excel screens an animated moving border roughly cells that were cut or copied. Come cancel a relocating border, press Esc.

Excel replaces existing data in the dough area once you cut and also paste cell to relocate them.

To choose details options as soon as you dough cells, you deserve to click the arrow below Paste , and then click the option that you want. Because that example, you deserve to click Paste Special or Picture.

By default, Excel screens the Paste Options button on the worksheet to provide you special options when you paste cells, such as Keep resource Formatting. If you don"t want to display this switch every time the you paste cells, you have the right to turn this choice off. Click the File tab, and then click Options. In the Advanced category, under Cut, Copy, and also Paste, clean the Show Paste choices button once content is pasted inspect box.


Move or copy cells by utilizing a mouse

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

Do among the following:

To relocate a cabinet or range of cells, point to the border the the selection. When the reminder becomes a relocate pointer

*
, traction the cabinet or selection of cell to another location.

To copy a cabinet or range of cells, hold down Ctrl if you suggest to the border the the selection. Once the tip becomes a copy tip

*
, traction the cabinet or selection of cell to an additional location.


Note: Excel replaces currently data in the paste area once you relocate cells.


When you copy cells, cell references automatically adjust. But, once you relocate cells, cell recommendations are no adjusted, and the materials of those cells and also of any cells that point to them may be presented as referral errors. In this case, you have actually to change the recommendations manually.

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


Insert relocated or replicated cells between existing cells

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

To relocate the selection, click Cut .

Keyboard shortcut girlfriend can also press Ctrl+X.

To copy the selection, click Copy .

Keyboard shortcut friend can likewise press Ctrl+C.

Right-click the upper-left cabinet of the paste area, and also then click Insert reduced Cells or Insert duplicated Cells.

Tip To move or copy a an option to a different worksheet or workbook, click an additional worksheet tab or move to another workbook, and then select the upper-left cell of the paste area.

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

Note If you insert whole rows or columns, the surrounding rows and columns are shifted down and also to the left.


Copy visible cells only

If part cells, rows, or columns top top the worksheet are not displayed, you have actually the alternative of copying every cells or only the clearly shows cells. Because that example, girlfriend can pick to copy just the displayed an introduction data on an outlined worksheet.

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

*

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

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

Keyboard shortcut you can also press Ctrl+C.

Select the upper-left cabinet of the dough area.


Tip: To relocate or copy a an option to a different worksheet or workbook, click one more worksheet tab or move to an additional workbook, and also then choose the upper-left cabinet of the paste area.


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

Keyboard shortcut you can also press Ctrl+V.

If girlfriend click the arrow below Paste , girlfriend can pick from numerous paste choices to use to her selection.

Excel pastes the copied data right into consecutive rows or columns. If the paste area contains hidden rows or columns, you might have come unhide the paste area to see every one of the replicated cells.

When girlfriend copy or paste surprise or filtered data to another application or one more instance of Excel, just visible cells are copied.


Prevent copied empty cells from instead of data

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

Keyboard shortcut you can also press Ctrl+C.

Select the upper-left cabinet of the dough area.

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

Select the Skip blanks examine box.


Move or copy simply the materials of a cell

Double-click the cell that consists of the data the you want to relocate or copy.

Note by default, you have the right to edit and select cell data directly in the cell by double-clicking it, however you can also edit and select cabinet data in the formula bar.

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

To relocate the selection, click Cut .

Keyboard shortcut you can additionally press Ctrl+X.

To copy the selection, click Copy .

Keyboard shortcut you can likewise press Ctrl+C.

In the cell, click where you desire to paste the characters, or double-click one more cell to move or copy the data.

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

Keyboard shortcut friend can likewise press Ctrl+V.

Press ENTER.


Note: When you double-click a cabinet or press F2 to modify the energetic cell, the arrowhead keys occupational only within the cell. To usage the arrow keys to relocate to one more cell, first press enter to complete your editing transforms to the active cell.


Copy cabinet values, cabinet formats, or recipe only

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

Paste only the cabinet formatting, such together font shade or fill shade (and not the contents of the cells).

Convert any kind of formulas in the cell to the calculated worths without overwriting the present formatting.

Paste only the formulas (and not 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 cell of the paste area or the cell whereby you desire to dough the value, cabinet format, or formula.

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

To paste values only, click Values.

To paste cell styles only, click Formatting.

To paste formulas only, click Formulas.


Note: If the copied formulas contain loved one cell references, Excel adjusts the references (and the relative parts of mixed cell references) in the duplicate formulas. Because that example, expect that cabinet B8 has the formula =SUM(B1:B7). If you copy the formula to cabinet C8, the duplicate formula refers to the corresponding cells in the column: =SUM(C1:C7). If the copied formulas contain absolute cell references, the referrals in the duplicate formulas room not changed. If you perform not get the results that you want, you deserve to also readjust the references in the initial formulas to either family member or pure cell references and then recopy the cells.


Copy cell width settings

When friend paste copied data, the pasted data offers the pillar width setups of the target cells. To correct the obelisk widths so the they match the source cells, follow these steps.

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

To relocate cells, click Cut .

Keyboard shortcut friend can likewise press Ctrl+X.

To copy cells, click Copy .

Keyboard shortcut girlfriend can additionally press Ctrl+C.

Select the upper-left cabinet of the paste area.


Tip: To relocate or copy a choice to a different worksheet or workbook, click an additional worksheet tab or switch to another workbook, and also then pick the upper-left cabinet of the paste area.


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

See more: What Stinks When Living And Smells Good When Dead, 30+ Riddles With Answers To Solve


Need much more help?

You can always ask an expert in the Excel tech Community or gain aramuseum.org in the answers community.


*
*
*

Need much more help?


Expand her skills
Explore Training
Get brand-new features first
Join aramuseum.org Insiders

Was this details helpful?


YesNo
Thank you! Any much more feedback? (The an ext you tell us the an ext 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 complement my screen
Incorrect instructions
Too technical
Not enough information
Not sufficient pictures
Other
Any additional feedback? (Optional)
Submit feedback

Thank girlfriend for your feedback!


×
What's new
aramuseum.org Store
Education
Enterprise
Developer
Company
English (United States) © aramuseum.org 2021