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.

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

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.

Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

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

Strictly Necessary Cookies Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

Transpose Excel For Mac