Turn Off Paste Options In Excel

It's nice to have a new laptop, but it's amazing how many options and settings need to be adjusted. For example, on my other machines I've changed the settings so those annoying Paste Options and AutoFill Options buttons don't appear. Now it's time to fix them on the new laptop. Does anyone actually use those buttons?

I'm also testing the latest version of Camtasia Studio, and it has some settings that I need to adjust too. Here's a video I created while changing the Paste/AutoFill options.

To turn off the buttons in Excel 2007:

  1. Click the Office Button, then click Excel Options
  2. Click Advanced, and in the Cut, Copy and Paste section, remove the check marks from 'Show Paste Options buttons' and 'Show Insert Options buttons'.
  3. Click OK

To turn off the buttons in Excel 2003 and earlier:

  1. On the Tools menu, click Options
  2. On the Edit tab, remove the check marks from 'Show Paste Options buttons' and 'Show Insert Options buttons'.
  3. Click OK


You may also like...

12 Responses

  1. Hi Debra,

    The little “box” is called a smart tag IIRC

  2. Doug Glancy says:

    “Does anyone actually use those buttons?” I do! I used to think they were silly but I use them all the time, mostly in Word and Outlook, and mostly using the “text only” or “destination formatting” options.

  3. Thanks Jan Karel and Doug. Glad to know that those smart tags are helping someone!

  4. dewey1973 says:

    I use them many times a day. Now if I could set the default behavior BEFORE I turned them off I’d do that instead. I hate the way the autofill assumes you want to increment dates and words that happen to end in a number. I’d also love to default the paste in Outlook to paste unformatted text.

  5. If you press the Ctrl key while dragging the fill handle, the dates and numbers won’t be incremented.
    Or for dates, press the right mouse button when dragging, and then select a fill option from the shortcut menu.

  6. Dave says:

    Ctrl+fill handle does not work when you double click the fill-handle. Still need the smart tag. Especially since the smart tag appears just above the status bar when auto filling with the fill handle below the “fold.” No scrolling with the fill handle drag option to find the bottom of a tens of thousands long data block. Oh, but I’m still using 2003. Maybe Ctrl+[double click fill handle] works after 2003…..

  7. Good point Dave. I usually use the double-click to fill down, followed by Ctrl+D, to change all the selected cells to the value in the first cell.

  8. Mike Reilly says:

    Thank you, thank you – I am so tired of this “helpful” garbage in new Office versions. I found Paste Options didn’t actually let me paste anything but just interfered with my attempts to copy something and paste it into multiple cells. Yet another in an endless list of “timesaving features” Microsoft somehow vomited up which need to be suppressed, shut off or eliminated in any way possible.

  9. Geoff Bennington says:

    Thanks a bunch! That has been driving me crazy.

  10. Lisa G says:

    I copy and paste from one excel workbook to another constantly. Is there a way to have excel 2007 consistantly paste into the destination formatting? It can be time consuming to pre-format data into my destination formatting and/or re-format it once the data is pasted.
    Thank you for your help.

  11. Frank says:

    Hi Guys,
    I have the Excel 2007. I started having some issues with my excel. When I copy and paste the cells, it’s pasting it as image. How can I get rid of this?
    Thank you in advance,,,

Leave a Reply

Your email address will not be published. Required fields are marked *