Pastes data validation rules for the copied cells to the paste area. Pastes only comments and notes attached to the copied cell. Pastes only cell formatting of the copied data. Pastes only the values of the copied data as displayed in the cells. Pastes only the formulas of the copied data as entered in the formula bar. Pastes all cell contents and formatting of the copied data. Note: Depending on the type of data you copied and the Paste option you picked, some other options might be grayed out. In the Paste Special box, pick the attribute you want to paste.
To use options from the Paste Special box, select Home, select the clipboard icon ( Paste), and select Paste Special. Reference to the source cells instead of the copied cell contents.Ĭopied image with a link to the original cells (if you make any changes to the original cells those changes are reflected in the pasted image).
Only the formatting from the copied cells. Data in rows is pasted into columns and vice versa.įormula(s), without formatting or comments.įormula results, without formatting or comments.
Reorients the content of copied cells when pasting. This table shows the options available in the Paste menu:Ĭopied cell content along with its column width. For example, to paste only formatting from the copied cell, select Formatting. Select Home, select the clipboard icon ( Paste) and pick the specific paste option you want.
0 kommentar(er)
