It helps us control what we want to copy from the source and what we dont.

I often refer to this option for various tasks, and here the shortcut of paste special in excel comes in handy.

Once you press this key combination, the paste special dialog box will open.

Each choice has a letter underlined that you can press on the keyboard to paste that property of copied cellrange.

To select an option from the list, we use the COMMANDletter key in mac.

It pastes the formatting of the copied range to the selected range.

In those cases, if you directly paste using CTRLV, excel will most likely paste all the components of source like formatting, checkboxes, radio buttons, etc.

When using the paste special, here you will get only three options; HTML, Unicode Text, and Text.

Others are Unicode Text and Text (press T for selecting Text).

These two options will paste plain text, that we desire most of the time.

The ASCII Text is useful when we work with multinational data or Mathematical and Scientific data.

If you hit the keys ALT-- E--S, one by one, it will open the Paste Special menu.

This is an old command that was used in Excel 2003 but it is still compatible.

If you have any ExcelVBA related query, ask it in the comments section below.

These 50 shortcuts can increase your productivity exceptionally on Excel.

In no event shall the owner of the copyrights, or the authors of the applicationscode be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applicationscode.

Home About Advertise With Us Excel Tips and Tricks Excel Editing Excel Format Newsletter Get latest updates from exceltip in your mail.

Information about your use of our site is shared with Google for that purpose Accept Home About Us Advertise With Us Quiz Page Excel Forum Commercial Services Formulas and Function.

You can adjust all of your cookie settings by navigating the tabs on the left hand side.

This means that every time you visit this website you will need to enable or disable cookies again.

Go To Special In Excel For Mac