Paste Special Feature in Excel (Using the Paste Special Dialog Box)

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

1.      Select the cell(s) whose values should be copied

2.      Windows: Press [Ctrl] + [C]
Macintosh: Press [] + [C]
OR
Windows: From the Home command tab, click COPY

Macintosh:From the Standard toolbar, click COPY

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

4.      Windows: From the Home command tab, click the PASTE arrow» select Paste Special...
Macintosh: From the Edit menu, select Paste Special...
The Paste Special dialog box appears.

5.      Select the desired options
EXAMPLE: To paste only the results of a formula, select Values

6.      Click OK
The results of the formula are pasted into the selected cell(s).

Related Posts by Categories