

My birthday is coming up, so let's say that I'm planning my ideal birthday weekend and I did it in a spreadsheet first. It's kind of like asking “How do you make a really great vinaigrette?” or “What is the best episode of Buffy the Vampire Slayer?” There is no one right answer The question is interesting, since it's not really that it's hard-there are just so many ways and many possible results. How do you get a spreadsheet into a Writer document? In these options, you have the option to keep source formatting (K), merge formatting (M), or keep text only (T), which pastes the text without any formatting.Alexander Kjerulf ( ) wrote to me with an excellent question. Clicking this box or pressing the Ctrl opens the paste options for that text. In new versions of Microsoft Office, when pasting text, a paste box appears in the bottom corner of the pasted text, as shown in the picture. If you want to paste text that is not formatted, click Unformatted text or Plain text. How to use paste specialįrom the file menu, click Edit and then choose Paste special or Paste text to open a dialog box similar to the above example. In the same way, you can use this command in Excel or Calc to copy formulas and calculations when pasting data into cells. Paste Special allows you several choices of how to format text when pasted. Below is an example of the choices that are offered when using paste special in Writer. Using paste special, you can choose to paste unformatted text (doesn't have a different font, isn't bold, doesn't contain links, etc.). It is very commonly used in Word, Excel, Writer, and Calc to provide special formatting or calculations when pasting content into a document.įor example, text copied from a web page often retains much or all HTML formatting, which may not match the colors, fonts, or other text formatting used in the document.

Paste special is a common feature in productivity software such as Microsoft Office and OpenOffice. Paste Special is a feature gives you more control of how the content is displayed or functions when pasted from the clipboard.
