Comments on: Excel Paste Special: copy values, comments, column's width and more

Copy pasting in Excel is easy. Everyone knows the shortcut to copy a cell and another one to paste it. But dis you know that apart from copying/pasting a whole cell, you can paste only a certain attribute such as value, formula, formatting or comment? That's where Excel Paste Special comes in. Continue reading →

Comments page 2. Total comments: 33

  1. Dear Sir/ Madam

    we need to know the shortcut formula of Special Paste without Special dialog from formula to values.

    Regards
    Buddhadev

  2. I really have to commend this blog post. It is the best I have read, giving a complete explanation of how to perform a task in multiple ways. Other sites just show you the obvious stuff which regular users of Excel already know. You also provide great examples in the tutorial. A+++

  3. Another reason why Paste Special does not work is the default settings in Evernote. Even when Evernote is not running, Ctrl+Alt+V creates a new note and pastes your clipboard contents into it. To change this, in Evernote go to Tools > Options > Shortcut keys and delete the shortcut for Paste clipboard, or change it to something else.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)