When I hit the Enter button, I get naked values. 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 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. 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 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. 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.
