How to Copy a Table from Excel on Mac (And Never Lose It)

How to Copy a Table from Excel on Mac (And Never Lose It)

Copying a table from Excel on Mac is straightforward until it isn't. You select, copy, switch apps, paste — and either nothing comes through, formatting breaks, or you realize you needed the previous table you copied ten minutes ago and it's gone.

This guide covers the core mechanics, common failure points, and how to stop losing tables you've already copied.

The Basic Steps to Copy a Table from Excel on Mac

1. Select the entire table.

Click the first cell of your table. Then hold Shift and click the last cell to select a range, or use Cmd+Shift+End to extend the selection to the last used cell in the sheet. To grab an entire named table, click any cell inside it and press Cmd+A — Excel will select just the table, not the whole sheet.

2. Copy the selection.

Press Cmd+C. Excel places a live "marching ants" border around the selection.

3. Paste into the destination.

Switch to your target app — Word, Pages, Numbers, an email client, a browser form — and press Cmd+V. What you get depends on the destination:

• Into Word or Pages: You get a formatted table with borders and cell structure intact.
• Into a text editor or email: You get tab-separated values, which is how Excel encodes a table in plain text.
• Into another Excel sheet: You get the full range, with or without formatting depending on whether you use Cmd+V (formatted) or Paste Special (Cmd+Ctrl+V).

Paste Special: Choosing What You Actually Paste

When plain Cmd+V gives you too much (formula results when you wanted the formulas) or too little (raw values when you needed the formatting), use Paste Special.

After copying your table, in the destination sheet go to Edit → Paste Special or press Cmd+Ctrl+V. The dialog lets you paste:

• Values only — strips formulas, pastes computed results
• Formats only — pastes the styling without the content
• Column widths — matches the source column sizes
• Formulas — pastes the formulas as-is

This is especially useful when copying a formatted summary table into a clean sheet where you want numbers without carrying over conditional formatting or data validation rules.

Why the Paste Looks Wrong in Other Apps

If you paste an Excel table into an app outside the Microsoft ecosystem and the columns run together or disappear, the issue is almost always how that app handles tab-separated text. Excel copies tables as tab-delimited text for non-spreadsheet destinations. Apps that don't interpret tabs as column separators will display everything as a single line or strip the delimiters.

Fix: Use Paste Special → Match Destination Formatting (in Word or Pages) or look for a "Paste as Table" option in the destination app. Alternatively, export the sheet as CSV first when a tab-delimited paste isn't being parsed correctly.

The Bigger Problem: Mac's Clipboard Holds One Item

macOS keeps exactly one thing in the clipboard at a time. Every new Cmd+C overwrites the previous copy. When you're pulling tables from multiple Excel sheets — or copying a table, navigating away, and accidentally copying something else — that table is gone.

This is a fundamental macOS limitation, not an Excel bug. The only way around it is a clipboard manager that runs in the background and captures every copy automatically.

Using ClipHistory to Recall Any Table You've Copied

ClipHistory is a macOS clipboard manager built in Rust and Tauri. It runs silently in the background and captures everything you copy — including Excel tables — the moment you press Cmd+C.

Here's how it fits into an Excel workflow:

Recall a table you copied earlier. Press Cmd+Shift+V to open your clipboard history. ClipHistory keeps the last 150 clips plus unlimited pinned clips. Find the table by scrolling or typing a few characters you remember from its content.

Pin tables you use repeatedly. If you copy the same summary table headers or a standard data structure regularly, pin it. Pinned clips stay permanently — they don't rotate out of the 150-clip limit.

Build a Paste Stack for multi-step pastes. If you need to paste several tables into a document in a specific order, queue them up in the Paste Stack. Each Cmd+V pulls the next item from the queue automatically.

Use Snippets for table templates. If you use the same structure repeatedly — a standard reporting table, a budget template — save it as a Snippet. It stays available forever, not subject to the 150-clip rotation.

Run AI Transforms on copied data. If you've copied a raw data table and want it summarized or cleaned before pasting elsewhere, ClipHistory's AI Transforms can rewrite, summarize, or fix any clip using your own API key from Anthropic, OpenAI, DeepSeek, Google, or a custom provider.

Everything stays local on your Mac. No account, no cloud, no data leaving your machine.

Get ClipHistory — $19.99 as an annual license (one payment, not auto-renewing).

Quick Reference: Copy Table Shortcuts in Excel for Mac

Common Issues and Fast Fixes

"My paste lost all the formatting." Use Paste Special and choose the appropriate format option. Or paste into the correct app — formatting survives best when you stay within Microsoft Office apps.

"I copied a new table and lost the previous one." This is macOS by design. A clipboard manager like ClipHistory prevents it by keeping a history automatically.

"My table pasted as one long line." The destination app isn't interpreting tab-delimited text as columns. Try a dedicated Paste Special option in that app, or export from Excel as CSV and import rather than paste.

"Excel won't copy — the marching ants disappear when I switch apps." Excel clears the clipboard marquee after a certain number of operations or when you double-click a cell. Re-select and re-copy, then switch apps without interacting with another cell first.