How to prepare a mac for resale. Excel for Office 365 Excel 2019 Excel 2016 Word 2016 Excel 2013 Word 2013 Excel 2010 Word 2010 Excel 2007 Word 2007 By default, Excel and Word display a Paste Options button on the worksheet or document to provide you with special options, such as Keep Source Formatting, when you paste content. If you don't want to see this button every time that you paste content, you can turn this option off.

This article explains how to show or hide the Paste Options button on a PC. For Mac procedures, see. • Click the File tab, then click Options.

Next, select cell D5, right click, and then click Formatting under 'Paste Options:' Result. Note: the Format Painter copy/pastes formatting even quicker. Paste Special. The Paste Special dialog box offers many more paste options. To launch the Paste Special dialog box, execute the following steps.