So Dick is the keyboard guru here, but there’s a lot of people that use the mouse a lot. I know I do. And I was reading Jensen Harris‘ blog today about how a Paste Special operation takes 6 clicks right now, but only 3 in Office 12.
However, there are a number of ways in which you can shorter this operation. One way, is to customize the toolbars, and display the ‘Paste Values’ button as shown in the screenshot.
The steps required to add this button are:
- Right click on any toolbar, and click ‘Customize’
- Click on the ‘Commands’ tab
- Select the ‘Edit’ category
- Scroll down in the commands list until you see the ‘Paste Values’ button
- Click and drag this button to the toolbar where you want it.
- Click on ‘Close’ and you’re done!
This reduces the number of clicks needed to 3 (Select Range, click on Copy, click on Paste Values).
However, there’s another method that blows people away each time I use it… it’s that cool factor I guess.
Take this data for example, I’m using =RAND(), just like Jensen is.
Now, select the range, right click and hold on one of the borders (*not* in the fill handle), drag the range as if you were going to move it to a different place, and then drag it back to its original position. Just offseting one row or column willl do the job.
When you release the mouse button, a popup menu will appear, giving you some pretty cool options, one of those being ‘Copy here as Values only’. Basically doing the Copy and Paste in one single operation.
I guess technically this is still a 3 click operation, but there’s a lot less mouse movement involved, and, you can use it to create links or hyperlinks for example.