Note: You need to hold Ctrl + ALT key together and then press “V” to open paste special dialogue box. Now hold “Ctrl + ALT” and press “V” to open the “Paste Special’ dialogue box. The second shortcut key is to open paste special dialogue box is “Ctrl + ALT + V” this will open up the paste special dialogue box, and from there on, press “V” to select the “Values” option.Ĭopy the range of cells to be pasted, then select the targeted cell where we need to paste as values. #2 – Paste Values Using Shortcut Key “Ctrl + ALT + V” After selecting the “Values” option, click on the “Ok” button to get only values.Here I have an excel table that is formatted and has formulas. Lets have some examples to see the paste special shortcuts in action. To select an option from the list, we use the COMMAND+letter key in mac. From this list, we need the option of “Values” so to select this option in this window, we can press the shortcut alphabet “V,” and it will choose the “Values” options in this “Paste Special” window. In mac, we use CTRL+COMMAND+V key combination to open the paste special dialog.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |