The basic copy-and-paste method works for most situations

To copy data from Excel, select the cells you want, press Ctrl+C (Windows) or Command+C (Mac), then paste into another program with Ctrl+V or Command+V. Excel preserves the cell contents — numbers, text, formulas, and formatting — so what you see in the spreadsheet is usually what you get when you paste elsewhere.

The simplest approach is to click on a single cell, then drag to select a range. If you need multiple separate areas, hold Ctrl (Windows) or Command (Mac) while clicking each area. Once selected, the cells show a moving dotted border around them, confirming they are copied to your clipboard.

Pasting works differently depending on where you paste. A text editor like Word or Google Docs receives the data as plain text or a straightforward table. Email programs usually paste as text. Other spreadsheets like Google Sheets or LibreOffice Calc preserve the formatting and formulas. The receiving program determines what happens next.

Key Takeaways

  • Select cells with your mouse or keyboard, then press Ctrl+C (Windows) or Command+C (Mac) to copy them to your clipboard.
  • Paste into another program using Ctrl+V or Command+V; the receiving program decides whether to keep formatting, formulas, or convert to plain text.
  • Use Paste Special to control exactly what gets pasted — formulas, values only, formatting, or comments — instead of pasting everything at once.
  • Copying entire columns or rows works the same way as copying individual cells, but watch for hidden rows or columns that will copy even though you cannot see them.
  • If your data contains line breaks within cells, copying to email or text programs may break the layout; export as CSV or PDF instead for cleaner results.

Selecting the right range without mistakes

Click on the first cell you want to copy. Then hold Shift and click on the last cell in the range. Excel highlights everything between them. This method works for rectangular blocks of data — rows and columns that form a solid rectangle on the screen.

If your data is not rectangular, or if you need to copy cells that are far apart, click the first cell, then hold Ctrl (Windows) or Command (Mac) while clicking each additional cell or range. Each selection adds to your clipboard without replacing the previous one. When you paste, all selected areas paste together in the same layout they had in Excel.

Watch for hidden rows or columns. If you select from row 1 to row 20, but rows 5 through 10 are hidden, those hidden rows copy anyway — you just cannot see them. To avoid this, unhide all rows and columns first. Right-click on the row or column headers, select Unhide, and choose All.

Using Paste Special to control what transfers

Paste Special lets you choose exactly what gets pasted — values only, formulas, formatting, or comments. This is useful when you want numbers without the formulas behind them, or when you want to paste into a program that does not understand Excel formulas.

After copying, go to the destination cell and press Ctrl+Shift+V (Windows) or Command+Shift+V (Mac). A dialog box opens with options. Select Values to paste only the numbers or text, leaving formulas behind. Select Formulas to paste the formulas themselves, which will recalculate based on the new location. Select Formatting to paste only colors, fonts, and borders without the data.

Most people use Paste Special when copying from one Excel file to another and want to avoid formula errors. If your original data contains a formula like =A1+B1, pasting as values converts it to the result — the actual number — so it does not change if the original cells change later.

Copying to Word, Google Docs, and email

When you paste Excel data into Microsoft Word or Google Docs, the program usually creates a table automatically. The table preserves column widths and alignment from Excel. If you want plain text instead, use Paste Special and choose Unformatted Text.

Email programs like Outlook and Gmail handle pasting differently. Outlook pastes as a formatted table if you use regular paste, but the table may not display correctly on all devices. Gmail converts pasted data to plain text with tabs between columns, which looks messy but copies reliably. If you need to send a spreadsheet, attach the Excel file itself rather than pasting into the email body.

For cleaner results in email or documents, consider exporting as a PDF or CSV file instead. A CSV file (comma-separated values) opens in any spreadsheet program and pastes as plain text into email. A PDF preserves the exact layout and looks professional, though the recipient cannot edit it.

Copying to Google Sheets and other spreadsheet programs

Google Sheets accepts Excel data directly. Copy from Excel and paste into Google Sheets using regular paste. Formulas convert automatically, and formatting transfers in most cases. If a formula does not work, Google Sheets may use slightly different syntax — for example, some functions have different names — and you may need to adjust it.

LibreOffice Calc and other open-source spreadsheet programs also accept Excel paste directly. The conversion usually works, but complex formulas or Excel-specific features may not transfer perfectly. Test the pasted data by checking a few formulas to make sure they calculated correctly.

If you are moving data permanently to another spreadsheet program, export the file as CSV or XLSX instead of copying and pasting. This preserves the data more reliably and avoids the clipboard size limits that can affect very large datasets.

Handling large amounts of data and special characters

Excel's clipboard has limits. If you try to copy more than about 8 million cells at once, or if your data is extremely wide, the copy may fail silently or paste incomplete. For large datasets, export as a CSV or XLSX file and open it in the destination program instead of copying and pasting.

Special characters like line breaks within cells, accented letters, or symbols from other languages usually copy correctly. However, if the receiving program does not support the same character set, some characters may appear as question marks or boxes. This is rare with modern programs, but it can happen when pasting into very old software or plain-text editors.

If your cells contain formulas that reference other sheets in the same workbook, those references may break when you paste into a different file. The formula tries to find the other sheet in the new location and fails. Use Paste Special with Values to convert formulas to their results before copying to a different file.

Copying column headers and keeping them visible

When you copy a large table, the headers (the top row with column names) copy along with the data. In the destination program, you may want to freeze the header row so it stays visible when scrolling. In Excel, select the row below the headers, then go to View and click Freeze Panes. In Google Sheets, select the header row and click View, then Freeze, then 1 row.

If you are pasting into Word or Google Docs, the table includes headers automatically. If you are pasting into email or a text editor, copy only the data rows without headers, or add headers manually in the destination.

Frequently Asked Questions

Why does my pasted data look different from the original?

The receiving program may not support the same formatting. Column widths, colors, and fonts sometimes do not transfer. If the data itself looks wrong — numbers appear as text, or formulas show as #REF! errors — use Paste Special and check whether you pasted formulas or values. Formulas may fail if they reference cells that do not exist in the new location.

Can I copy data from a closed Excel file without opening it?

No. You must open the file in Excel to copy from it. However, you can open the file, copy the data, and close it without saving changes. If you want to copy from multiple files, open each one, copy what you need, and paste into a single destination file.

What is the difference between copying and exporting?

Copying uses the clipboard and works for any amount of data that fits in memory. Exporting saves the file in a different format — CSV, PDF, or another program's native format — and works better for large files or when you need to send the data to someone else. Export when you want a permanent file; copy when you want to move data between open programs.

Does copying preserve formulas or just the results?

Regular paste copies formulas, and they recalculate in the new location based on the new cell references. If you want only the numbers or text results, use Paste Special and select Values. This converts formulas to their current results and prevents them from changing later.

Can I copy from Excel on my phone or tablet?

Excel for iPhone and iPad supports copy and paste the same way as the desktop version. Select cells, press the copy button (or use the keyboard shortcut if your device has one), then paste into another app. The process is slower on a small screen, so consider using a desktop computer for large amounts of data.