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?
Video: Turn Off Paste Options
Here’s a video I created while changing the Paste/AutoFill options.
Note: I’m also testing the latest version of Camtasia Studio, and it has some video recording settings that I need to adjust too!
To turn off the buttons in Excel 2007:
- Click the Office Button, then click Excel Options
- Click Advanced, and in the Cut, Copy and Paste section, remove the check marks from ‘Show Paste Options buttons’ and ‘Show Insert Options buttons’.
- Click OK
To turn off the buttons in Excel 2003 and earlier:
- On the Tools menu, click Options
- On the Edit tab, remove the check marks from ‘Show Paste Options buttons’ and ‘Show Insert Options buttons’.
- Click OK
_________________
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.
Thanks Debra, didn’t know about the Ctrl-D option after double-click, just what I was looking for.
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.
Thanks a bunch! That has been driving me crazy.
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.
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,,,
PASTE SPACIAL USE
1 COPY
2 RIGHT CLICK THEN then select value & click (OK)
thank you
9165052730