I hit the v key (v is underlined on value option). Now press the shortcut Ctrl + Alt + v in windows to open the paste special shortcut. Here I have an excel table that is formatted and has formulas in it. Let's understand how to use the function using an example. To select an option from the list, we use the COMMAND+letter key in mac.Īs you can see it's very similar for both operating systems whether its windows or macs.Īll of these might be confusing to understand. ![]() In mac, we use CTRL+COMMAND+V key combination to open the paste special dialog. Each choice has a letter underlined that you can press on the keyboard to paste that property of copied cell/range. Here you will have many choices for pasting your data. Once you press this key combination, the paste special dialog box will open. In windows, the keyboard shortcut for paste special is Ctrl + Alt + v. Let's learn how to use the Paste Special dialog box here. I often refer to this option for various tasks, and here the shortcut of paste special in excel comes in handy. ![]() It helps us control what we want to copy from the source and what we don't. The paste special feature is undoubtedly a very useful option in Excel. In this article, we will learn Expanded Paste Icon Features in Excel.
0 Comments
Leave a Reply. |