This converts all formulas to values and strips all formatting. In cases where you just want to get the data without any formulas, use Paste Special with V for Values. This table is a mix of regular data and formulas, along with various formatting. On the Mac, you'll need to type the Command key plus a letter. In Windows, you can type a letter to select options. Using this shortcut doesn't actually finish the Paste, it simply displays the Paste Special dialog, where you can choose which options you want. ![]() To use Paste Special, just copy normally, then use the shortcut Ctrl + Alt + V in Windows, Ctrl + Command + V on the Mac. ![]() ![]() In this video, we'll review shortcuts and commands for Paste Special.Īs you might already know, Paste special is a gateway to many powerful operations in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |