Why does formatting sometimes get messed up when you cut and paste text? And what is that thing that appears at the end of the last sentence every time you paste–like a fly returning to honey.
It's an add-in for MS Excel, and generates images in PNG and JPG format. Minimum of 300dpi for figures), and found that this way by University of Kent is the best. Copy the excel graph and paste it in Microsoft image digital editor. By clicking on the section resize image, you can manipulate the resolution as well as size.
That thing–the Paste Options button–is your friend, a worker bee and not a fly whose only job is to follow your formatting instructions. Learning how it works keeps you from wasting time manually formatting pasted text.
Using the Paste Options button
Click the down-arrow on the Paste Options button and you’ll see a menu with icons that lets you format copied text in different ways. The options you’ll see depend on where you’re cutting and pasting from and to, e.g., from within or between documents. Roll your mouse over the icons and you can see how your pasted text will look before you click.
These are the four most common options:
- Keep Source Formatting: Keeps the formatting of the text you copied
- Use Destination Styles: Matches the formatting where you pasted your text
- Kept Text Only: Discards both the text formatting AND the non-text elements you copied, such as pictures or table, and then matches the formatting where you pasted the text
- Merge Formatting: Keeps the formatting of the text you copied without changing the formatting of the destination document, e.g., if you cut and paste a sentence from another document that had a different font type or size
Word gives you other options for copying and pasting things such as bulleted or numbered lists, or hyperlinks. Plus, it lets you define how you want cutting and pasting to work most of the time (click Set Default Paste under the icons)–including getting rid of the Paste Options button if it still seems like a pesky fly.
Microsoft Word
Put your best words forward with an Office 365 subscription.
Get WordIf you’re working with Office 2011 for Mac, you’ll be glad to know that it’s easy to move your charts from Excel to Word and PowerPoint. You can even create a chart directly in Word 2011 for Mac and PowerPoint 2011 for Mac. Easy is good!
The process of copying Excel charts into Word or PowerPoint is straightforward. Follow these steps:
- Make sure that Excel and the destination application (Word or PowerPoint) are open.In Excel, the currently open workbook needs to contain the chart you want to copy to Word or PowerPoint.
- Select the chart in Excel by clicking its border.The selection indicator is a thick, blue outline replacing the border.
- Copy the chart.Use any of the usual methods: Click the Copy button on the Standard toolbar, press Command-C, or choose Edit→Copy.
- Switch to the Microsoft Word document or PowerPoint presentation.Use the Dock or press Command-Tab.
- Paste the chart.Use any of the usual methods: Click the Paste button on the standard toolbar, press Command-V, or choose Edit→Paste.
- Click the small widget in the lower-right corner of the chart.A drop-down menu appears. The widget for Word is on the left, and the widget for PowerPoint is on the right.
- Choose how you want the chart to behave while it’s living in your Word document or PowerPoint presentation:
- Paste as Picture or Picture of Chart: Office converts your chart to a picture, and then pastes a picture of the chart into your document or presentation.
- Excel Chart (Entire Workbook): Pastes a copy of the entire workbook as an embedded OLE (Object Linking and Embedding) object into the Word document or PowerPoint presentation, displaying the chart. Chart colors and fonts adopt document theme colors of the paste destination.
- Chart (Linked to Data): This is the default option and pastes a chart object in your document or presentation. The data is linked to the Excel source workbook, which remains an independent Excel file. After updating the chart in Excel, in Word you refresh the chart by choosing Edit→Links→Update Links. PowerPoint links update automatically. Selecting the pasted chart in Word or PowerPoint activates the Charts and Format tabs on the Ribbon.
- Keep Source Formatting: Word or PowerPoint doesn’t apply its existing document theme but instead retains Excel’s source colors and fonts.
- Use Destination Theme: This is the default paste. The chart adopts the Word document or PowerPoint presentation’s theme.
- Click outside the drop-down list to close the widget.