MS Excel Display the ‘Paste Special’ dialog box

  • Home
  • Blogging
  • MS Excel Display the ‘Paste Special’ dialog box

MS Excel Display the ‘Paste Special’ dialog box

MS Excel Display the ‘Paste Special’ dialog box

This shortcut -

Control + Alt + V (Mac: Control + Command + V)

This will open the Paste Special dialog box. At that point, you'll need to choose the type of paste you want to perform. (Of course, you can also right-click and choose Paste Special to display this dialog box.)

There are so many things you can do with paste special:

  • you may already use paste special to strip out unwanted formatting and formulas (Paste special > Values)
  • but did you know that you can also paste formatting, paste column widths, multiply and add values in place, and even transpose tables?

This feature is extremely useful.

Blogging, Microsoft Office
3 comments

Written by

Patricia Self

View all posts by:

3 Comments

  1. altyazili
    This very blog is obviously cool and diverting. I have discovered many useful tips out of it. I ad love to visit it again soon. Cheers! Windy Farley Dev
    Reply
    February 8, 2021
  2. yabanci
    Never mind my message from 1 year ago. This method is easy to set-up and works like a charm. Thanks for sharing. Marti Alfons Wenz
    Reply
    February 8, 2021
  3. mp3
    Well I truly liked reading it. This information provided by you is very effective for accurate planning. Elianore Emmott Rollins
    Reply
    February 9, 2021

Leave a reply