Paste special in MS Excel

Using the Paste Special Dialog Box Options

The Paste Special dialog box allows you to select which aspects of the copied data you would like to paste.

Paste special in MS Excel

Select the cell(s) whose values should be copied

Press [Ctrl] + [C]

OR

From the Home command tab, click COPY

Select the cell(s) where the results should be pasted

From the Home command tab, click the PASTE arrow » select Paste Special...

OR

Press Ctrl + Alt + V Shortcut from keyboard

The Paste Special dialog box appears.

Select the desired options

EXAMPLE: To paste only the results of a formula, select Values

Click OK

The results of the formula are pasted into the selected cell(s)

If my posts are useful for you، or if there is any reduction in them so kindly comment me.