short cut key on excel mac for paste special

Copying any number from one place and Divide it by other selected numbers in a range of cells.

Using this feature, you can paste several formats like, formulas, values, formats, comments, data validation, number formats.

Also, you can add, multiply, subtract, or divide a specific number to the selected range of cells in a worksheet.

To use Paste Special feature in excel, follow the shortcut keys given below the picture.

Or use table of contents to navigate easily (given below the picture).

Right click on the worksheet, then select the Paste Special after copying the selected content from the cell.

Paste all data with all formatting that you have copied the contents from the selected cells.

Formulas.

Paste the content without formula that you have copied the contents from the selected cells.

Paste only formatting (not content) that you have copied from the selected data.

Paste only data validation that you have applied to the contents from the Data tab, in the Data Tools group.

Paste all the contents along with source theme formatting from the selected data in the cells, which are applied with theme format from the layout tab.

Paste all the contents without borders that you have copied the contents with borders.

Paste or apply the same column width that you have copied from the selected cells.

Formulas and Number Formats Press R Press Enter key or click OK.

Values and Number Formats Press U Press Enter key or click OK.

Paste only number formats and content without formula that you have copied the contents from the selected cells.

All Merging Conditional Formatting Press G Press Enter key or click OK.

Paste all the contents along with source theme formatting and Conditional Formatting from the selected data in the cells, which are applied with theme format from the layout tab, and Conditional Formatting from the Home tab, in the Styles group.

Paste Special Operators Keyboard Shortcut Description Add Press G Press Enter key or click OK.

Copying any number from one place and Add it to other selected numbers in a range of cells.

Copying any number from one place and Subtract it from other selected numbers in a range of cells.

Copying any number from one place and Multiply it to other selected numbers in a range of cells.

Short Cut Key On Excel Mac For Paste Special