Learn Excel - Lesson 7: Move & copy cell contents in Excel

Let's continue learning how to copy or move cell content in Microsoft Excel!

Use Cut, Copy and Paste to move, copy cell contents or certain data or attributes in cells. For example, copying the result value of a formula without copying it or just "copying" the formula.

Excel will move or copy the cells you want, including formulas, result values, formatting, and internal comments.

You can move cells in Excel by dragging and dropping or using the Cut & Paste command .

Move cells by drag & drop

  1. Select the cell or range of cells you want to copy or move.
  2. Point the mouse to the border surrounding the selection.
  3. When the cursor is shaped Learn Excel - Lesson 7: Move & copy cell contents in Excel, drag the cell or range of cells to another location.

Move cells by Cut & Paste

  1. Select a cell or range of cells.
  2. Select Home> CutLearn Excel - Lesson 7: Move & copy cell contents in Excel or press Ctrl+ X.
  3. Select the cell where you want to transfer the data.
  4. Select Home> PasteLearn Excel - Lesson 7: Move & copy cell contents in Excel  or press Ctrl+ V.

Copy the cell in the worksheet with the Copy & Paste command .

  1. Select a cell or range of cells.
  2. Select Copy or press Ctrl+ C.
  3. Select Paste or press Ctrl+ V.

Move or copy cells

1. Select the cell you want to move or copy.

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

Learn Excel - Lesson 7: Move & copy cell contents in Excel
  • To switch cells, click CutLearn Excel - Lesson 7: Move & copy cell contents in Excel or Ctrl+ X.
  • To copy cells, click CopyLearn Excel - Lesson 7: Move & copy cell contents in Excel or Ctrl+ C.

3. Select the upper left box of the data pasted area.

Tip: To move or copy a selection to another worksheet or workbook, click the worksheet tab or switch to another workbook, then select the upper left box of the pasted area.

4. On the Home tab , in the Clipboard group , click Paste or press Ctrl+ V.

Note:

  • Excel displays a dynamic border that moves around the cut or copied cells. To cancel this border, press Esc .
  • Excel replaces the current data in the paste area when you cut & paste cells to move them.
  • For specific options when pasting cells, you can click the arrow below Paste , and then click the desired option. For example, click Paste Special or Picture .
  • By default, Excel displays the Paste Options button on the worksheet to provide special options when pasting cells like Keep Source Formatting . If you do not want this button to appear every time you paste a cell, you can turn this option off. Click the File tab > Options . In the Advanced category , in Cut, Copy & Paste , uncheck the Show Paste Options button when content is pasted .

Move or copy cells with the mouse

By default, drag & drop editing is enabled so you can move and copy cells with your mouse.

  1. Select the cell or range of cells you want to copy or move.
  2. Do one of the following:
  • To move a cell or range of cells, point to the selected border. When the cursor has a shape Learn Excel - Lesson 7: Move & copy cell contents in Exceldragging the cell or range of cells to another location.
  • Copy a cell or a range of cells, hold down the Ctrl key while you point to the selection border. When the cursor switches Learn Excel - Lesson 7: Move & copy cell contents in Excel, drag the cell or range of cells to another location.

Note: Excel replaces the current data in the pasted area as you move cells.

When copying cells, their references are automatically adjusted. However, when moving the cell, it will not happen. The contents of these cells and any cells that point to them can be displayed as reference errors. In this case, you must adjust those references manually.

If the selected range includes hidden cells, rows or columns, Excel copies them. You may have to unhide temporary data you don't want to include when copying information.

Insert moved or copied cells between current cells

1. Select the cell or range of cells containing the data you want to copy or move.

2. On the Home tab > Clipboard , do one of the following:

  • To move the selection, click Cut or press Ctrl+ X.
  • To copy the selection, click Copy or press Ctrl+ C.

3. Right-click in the upper left box of the pasted area, and then click Insert Cut Cells or Insert Copied Cells .

Tip: To move or copy a selection to another worksheet or workbook, click the worksheet tab or switch to another workbook, then select the box to the left above the current pasted area.

4. In the Insert Paste dialog box , click the direction you want to move to the surrounding box.

Note: If inserting entire rows or columns, surrounding rows and columns are moved down or to the left.

Copy only the visible cells

If some cells, rows or columns on the worksheet do not show, you have the option to copy the entire cell or just the cells that appear. For example, you can choose to copy only the summary data on the annexed worksheet.

1. Select the cell you want to copy.

2. On the Home tab > Editing > click Find & Select > Go To Special .

Learn Excel - Lesson 7: Move & copy cell contents in Excel

3. In Select , click Visible cells only> OK .

4. On the Home tab > Clipboard > click Copy or press Ctrl+ C.

5. Select the box at the upper left of the paste area.

6. On the Home tab > Clipboard > click Paste or press Ctrl+ V.

If you click the arrow below Paste , you may have several data paste options to apply.

Excel pastes the copied data in consecutive rows & columns. If the paste area contains hidden rows or columns, you may have to unhide the paste area to see the entire copied cell.

When copying or pasting hidden or filtered data into another application / version of Excel, only the visible cells are copied.

Prevent copying blank cells from replacing data

  1. Select the range containing empty cells.
  2. On the Home tab > Clipboard > Copy or press Ctrl+ C.
  3. Select the upper left box of the pasted area.
  4. On the Home tab > Clipboard , click the arrow under Paste and click Paste Special .
  5. Select the Skip blanks checkbox .

Move or copy only the content of a cell

1. Double-click the cell containing the data you want to move or copy.

Note: By default, you can edit & select data directly in that cell by double clicking on it, but, you can also edit & select cell data in the formula bar.

2. In that cell, select the character you want to copy or move.

3. On the Home tab > Clipboard > do one of the following:

  • To switch your selection, click Cut or press Ctrl+ X.
  • To copy the selection, click Copy or press Ctrl+ C.

4. In this box, click the location where you want to paste the characters, or double-click the other cell to transfer or copy data.

5. On the Home tab > Clipboard, click Paste or press Ctrl+ V.

6. Press Enter .

Note: When you double-click a cell or click F2to edit the active cell, the arrow keys only function in that cell. To use the arrow keys to move it to another cell, first press Enter to complete the editing changes to the active cell.

Copy values, formats or just formulas in cells

When pasting copied data, you can do one of the following:

  • Only paste cell formats like font color or fill color (and not the contents of those cells).
  • Convert any formula in that cell to calculated values ​​without overwriting the current format.
  • Paste the formula only (not the calculated value).
  • Select the cell or range of cells containing the value, format or formula you want to copy.
  • On the Home tab > Clipboard > Copy or press Ctrl+ C.
  • Select the cell to the upper left of the paste area or cell where you want to paste the value, format or formula in the cell.
  • On the Home tab > Clipboard > click the arrow below Paste , and then do one of the following:
    • Click Values to paste the value only.
    • Click Formatting to paste the formatting only.
    • Click Formulas to paste only the formula.

Note : If the copied formula contains relevant cell parameters, Excel will adjust these references (and other relevant parts) in the copied formula. For example, suppose that cell B8 contains the formula = SUM (B1: B7). If you copy this formula to cell C8, the duplicate formula refers to the corresponding cell in that column: = SUM (C1: C7). If the copied formula contains absolute cell references, the references in the copied formula do not change. If you don't get the results you want, you can also change the reference in the original formula to reference the absolute or related cell, and then copy those cells again.

Copy the cell width setting

The copied data is pasted using the column width setting of the target cells. To adjust it to match the source cell, do the following:

1. Select the cell you want to move or copy.

2. On the Home tab > Clipboard , do one of the following:

  • To move the cell, click Cut or Ctrl+ X.
  • To copy cells, click Copy or Ctrl+ X.

3. Select the upper left box of the pasted area.

Tip: To move or copy a selection to another worksheet or workbook, click the worksheet tab or switch to another workbook, then select the box to the left above the pasted area.

4. On the Home tab , in the Clipboard , click the arrow in Paste , and then click Keep Source Column Widths .

Above is how to move cells or copy cell content in Excel. Hope the article is helpful to you.

Sign up and earn $1000 a day ⋙

Leave a Comment

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel. Why do some Excel documents not display data or contain blank pages when printed? Below are the reasons

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar, How to pin Office files to the taskbar icon on Windows 11? Invite

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save an Excel file on Windows. If you can't save the Excel file, don't worry too much. Below are ways to fix the error of not being able to save the above Excel file

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel, You can easily insert pictures into Excel spreadsheets and edit them with macro code. Here's how to insert images

How to enable auto-capitalization of the first letter of a sentence in Excel

How to enable auto-capitalization of the first letter of a sentence in Excel

How to enable auto-capitalization of the first letter of a sentence in Excel, Turning on the automatic-capitalization of the first letter of a sentence in Excel will save you a lot

How to calculate seniority work on Excel spreadsheets

How to calculate seniority work on Excel spreadsheets

Through this tutorial, WebTech360 will guide you how to calculate the seniority of a list of employees in the company via Microsoft Excel spreadsheet or WPS Spreadsheets.

IF and IFS functions in Excel: Usage and specific examples

IF and IFS functions in Excel: Usage and specific examples

The IF function in Microsoft Excel is one of the most commonly used logical functions. In the simplest sense, the IF function will return a result based on one or several input comparison data.

Learn Excel - Lesson 6: How to filter unique values ​​and delete duplicate values ​​in Excel

Learn Excel - Lesson 6: How to filter unique values ​​and delete duplicate values ​​in Excel

Filtering unique values ​​and deleting duplicate data is a basic operation that everyone needs to know when using Excel. Join us to learn how to do it in Excel!

How to use VLOOKUP, INDEX, ... in Excel you should know

How to use VLOOKUP, INDEX, ... in Excel you should know

The functions VLOOKUP, INDEX, MATCH, ... are quite complex functions but are effective in data mining in Excel. In this article, I will guide you in detail how to use VLOOKUP and related functions effectively.

Instructions for deleting horizontal lines in Word

Instructions for deleting horizontal lines in Word

Word, an indispensable tool for office workers when editing documents and editing documents to create professionally presented and arranged documents, Word often comes with Excel and PowerPoint in the Microsoft Office suite, caters to many types

Learning Excel - Lesson 11: Importing and exporting text files

Learning Excel - Lesson 11: Importing and exporting text files

There are two simple ways to import data from a text file (.txt or .csv) into Excel. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu.

What is the difference between Excel and OpenOffice?

What is the difference between Excel and OpenOffice?

OpenOffice is an office suite built on open source. Like Excel, this toolkit can be used on computer systems using Windows or Linux operating systems.

How to insert a PDF file into Excel

How to insert a PDF file into Excel

Adding PDF files to Excel will make working with this spreadsheet tool much more efficient and professional.

Instructions for sending emails from Excel spreadsheets using VBA scripts

Instructions for sending emails from Excel spreadsheets using VBA scripts

Using VBA scripts in Excel does not require any programming knowledge. VBA helps you do many advanced tasks such as creating a spreadsheet report containing all PC information, emailing directly from a spreadsheet ...

Create charts that automatically update data in Excel 2016

Create charts that automatically update data in Excel 2016

You can create automatically updated charts according to newly added data in Excel with just three simple steps.

Zooper Widget for Android 2.36 - Latest Version Updates for 2024 and 2025

Zooper Widget for Android 2.36 - Latest Version Updates for 2024 and 2025

Discover the latest updates in Zooper Widget for Android. Zooper Widget is a compact, highly customizable, and battery-friendly widget with endless possibilities.

Lipp for iOS 4.4 - Make lip sync and voiceover videos on iPhone / iPad 2024, 2025

Lipp for iOS 4.4 - Make lip sync and voiceover videos on iPhone / iPad 2024, 2025

Lipp for iOS, alongside Dubsmash and Musical.ly, provides iPhone and iPad users with a new platform to create lip sync videos and dub videos readily.

How to Share Audio with TeamViewer - Latest Version Updates 2024, 2025

How to Share Audio with TeamViewer - Latest Version Updates 2024, 2025

Learn how to share audio using TeamViewer, including the latest updates for 2024 and 2025, making remote communication more effective.

Adorable Home: Latest Tips for Petting Your Cat in 2024 and 2025

Adorable Home: Latest Tips for Petting Your Cat in 2024 and 2025

Learn the latest tips on how to pet a cat in Adorable Home for optimal gameplay in 2024 and 2025. Discover what positions give you hearts.

OrangeHRM Open Source 3.2.1 - Latest Features for 2024 and Beyond

OrangeHRM Open Source 3.2.1 - Latest Features for 2024 and Beyond

Explore the latest features of OrangeHRM Open Source, a free HR management system tailored to meet evolving business needs in 2024 and 2025.

How to Fix IDM Error Not Catching Download Links - Updates for 2024 and 2025

How to Fix IDM Error Not Catching Download Links - Updates for 2024 and 2025

Fix IDM not catching file download links. Discover solutions for downloading videos, music, and more with the latest IDM updates in 2024 and 2025.

The File Converter for Android - Convert files to other formats - Updated Versions 2024, 2025

The File Converter for Android - Convert files to other formats - Updated Versions 2024, 2025

Discover the latest version of The File Converter for Android, an application that converts various file formats efficiently.

Updated Zalo Web Login Features for 2024-2025

Updated Zalo Web Login Features for 2024-2025

Explore the latest features of Zalo Web, allowing users to chat and connect seamlessly on various browsers without installation.

PDF Password Remover 6.0 - The Ultimate Solution for Password Removal in PDF Files

PDF Password Remover 6.0 - The Ultimate Solution for Password Removal in PDF Files

PDF Password Remover is a powerful tool for removing passwords and restrictions from PDF files. Download the latest version for 2024 to experience enhanced features.

Latest Instructions for Completely Removing Internet Download Manager (IDM) - Updated for 2024 and 2025

Latest Instructions for Completely Removing Internet Download Manager (IDM) - Updated for 2024 and 2025

Step-by-step instructions to completely remove Internet Download Manager (IDM) from your system in 2024 and 2025. Learn to uninstall IDM effectively and cleanly.

Mindjet MindManager 2024 & 2025 - Empower Your Mind Mapping

Mindjet MindManager 2024 & 2025 - Empower Your Mind Mapping

Discover Mindjet MindManager, an innovative software that helps individuals and teams streamline their work processes through effective mind mapping and project management.

Su Doku 2.0.0 - Latest Updates 2024 & 2025

Su Doku 2.0.0 - Latest Updates 2024 & 2025

Su DoKu 2.0.0 is an advanced Sudoku game design software that captivates enthusiasts with its simplicity and functionality. Download now and challenge yourself with Sudoku puzzles.

Google Photos for Android - Unlimited Photo and Video Storage with Latest Features in 2024, 2025

Google Photos for Android - Unlimited Photo and Video Storage with Latest Features in 2024, 2025

Discover the new features of Google Photos for Android in 2024 and 2025, including faster backup and advanced search capabilities.

Updated IQmango DVD Ripper 2024 - New Features and Enhancements

Updated IQmango DVD Ripper 2024 - New Features and Enhancements

Discover the latest version of IQmango DVD Ripper in 2024, a powerful software to easily rip, copy, convert, and back up DVDs.

When2meet - Tools to Arrange Group Meetings (Updated 2024, 2025)

When2meet - Tools to Arrange Group Meetings (Updated 2024, 2025)

When2meet is an easy-to-use group meeting scheduling tool for organizing collaborative meetings. Discover the latest features of When2meet for 2024 and 2025.