Software

Ask something
Discussion Locked

Excel clipboard format

0 helpful
7 replies

by desktop jinx

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When copying a single cell from an Excel spreadsheet to the clipboard, it's formatted with a newline. This causes problems pasting into other applications. Is there any way to tell Excel to simply copy the number and not pad it with a trailing newline?

7 replies

by cactus pete

Instead of just clicking on the cell and copying the whole cell, try copying just the data within the cell.

Keyboard shortcut for doing this, once on the correct cell:

F2
Shift+Home
Ctrl+C

Then paste to the other document.

The key hereis to copy from within the cell, not the whoole cell itself.

by firstpeter

This doesn't address the issue of how it looks on the clipboard, but if you're using Word as your end application, for instance, you can do a "Paste Special" that pastes it as Unformatted or Rich Text (the former if you don't need to preserve the color, font size, etc.).

You could also build a macro to "translate" the cell into an unformatted state (i.e., no line break), but that might be overkill. I can help you pursue that option if you'd like - send me an e-mail.

by firstpeter

I'm not sure I can help on the copying portion (to the clipboard), but if you're pasting it to another Office application you can use the "Paste Special" option and select Unformatted Text or Rich Text to paste it. My trials with Excel to Word removed the newline that way...

This discussion is closed to new replies.