Tips.Net > ExcelTips Home > Editing > Turning Off Paste Options
Turning Off Paste Options
Summary: Paste options, a feature new to Excel 2002 and Excel 2003, can be distracting to some Excel users. Fortunately you can turn off the feature by following the steps outlined in this tip. (This tip works with Microsoft Excel 2002, and Excel 2003.)
Excel 2002 and Excel 2003 include a feature that really annoys some people: Paste Options. When you paste some tidbit of information in your worksheet, Excel displays a small, floating "button" right near the end of the pasted information. The button looks like the Paste tool on the toolbar: a small clipboard with a piece of paper over it. This is the Paste Options button. If you move your mouse pointer over the button, you find that it is really a drop-down menu, and clicking on the menu gives you a few options that you can apply to what you just pasted.
If you find the Paste Options button distracting, or if you never use it, you may want to turn it off. Follow these steps:
- Choose Options from the Tools menu. Excel displays the Options dialog box.
- Make sure the Edit tab is displayed. (Click here to see a related figure.)
- Clear the Show Paste Options Buttons check box.
- Click on OK.
Tip #3040 applies to Microsoft Excel versions: 2002 2003
Save Time! You can have this tip (and several hundred just like it) in the ExcelTips annual archives. Imagine having over 400 tips available at your fingertips, in each annual volume.
Fast Answers!
It doesn't matter if you are a beginner or expert, the ExcelTips archives are the fastest way to improve your productivity. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site