O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Embedding vs. Static Pasting

What's the difference between embedding something and doing an ordinary paste from the Clipboard?

If you paste text into Excel from Notepad (an application that doesn't support embedding), that text arrives as though you typed it directly into the active worksheet cell. (If the text spans multiple lines, Excel delivers each new line to a new cell in the current column.) What you paste, in other words, becomes ordinary worksheet data.

If you embed text from Word (or another word processor that supports embedding), the text appears to land in the cell that was active when you performed the embedding, but in fact it "floats" above the worksheet cells in an "object layer." Excel displays the text in an opaque rectangle that's ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required