True False sc/res/paste_formats_only.png 3 True False sc/res/paste_transpose.png 3 True False sc/res/paste_values_formats.png 3 True False sc/res/paste_values_only.png 3 False 6 Paste Special False dialog False vertical 12 False end _OK True True True True True True False True 0 _Cancel True True True True False True 1 _Help True True True True False True 2 True False True end 0 True False 6 24 True False start True 0 none True False 12 3 6 vertical 6 True False vertical 6 True Values Only True True True Values Only img_paste_values_only True top True Pastes numbers, text, dates and the results of formulas. False True 0 Values & Formats True True True Values & Formats img_paste_values_formats True top True Pastes cell values, formula results and formats applied to cells. False True 1 Formats Only True True True Formats Only img_paste_formats True top True Pastes only the formats from the source range without changing the values in the destination range. False True 2 Transpose All True True True Transpose All img_paste_transpose True top True Pastes cell contents transposed, hence columns are converted to rows. False True 3 False False 0 Run immediately True True False True True True Check this option to run the preset immediately. Uncheck it to manipulate the options before clicking OK. True True 1 True False Presets 0 0 True False start vertical True False 12 True 0 none True False 12 3 6 All True True False True True Pastes all cell contents, comments, formats, and objects into the current document. 0 0 Numbers True True False True True Inserts cells containing numbers. 0 1 Text True True False True True Inserts cells containing text. 0 2 Date & time True True False True True Inserts cells containing date and time values. 0 3 Formats True True False True True Inserts cell format attributes. 0 4 Comments True True False True True Inserts comments that are attached to cells. If you want to add the comments to the existing cell content, select the "Add" operation. 0 5 Objects True True False True True Inserts objects contained within the selected cell range. These can be OLE objects, chart objects, or drawing objects. 0 6 Formulas True True False True True Inserts cells containing formulae. 0 7 True False Paste False True 0 True False 12 True 0 none True False 12 3 vertical 3 Don't shift True True False True True True Inserted cells replace the target cells. False True 0 Down True True False True True no_shift Target cells are shifted downward when you insert cells from the clipboard. False True 1 Right True True False True True no_shift Target cells are shifted to the right when you insert cells from the clipboard. False True 2 True False Shift Cells False True 1 1 0 True False start vertical top True False 12 True 0 none True False 12 3 6 As Link True True False True True Inserts the cell range as a link, so that changes made to the cells in the source file are updated in the target file. To ensure that changes made to empty cells in the source file are updated in the target file, ensure that the "Paste All" option is also selected. 0 0 Transpose True True False True True The rows of the range in the clipboard are pasted to become columns of the output range. The columns of the range in the clipboard are pasted to become rows. 0 1 Skip empty cells True True False If enabled, blank cells in source will not override the target. True True Empty cells from the clipboard do not replace target cells. If you use this option in conjunction with the "Multiply" or the "Divide" operation, the operation is not applied to the target cell of an empty cell in the clipboard. 0 2 True False Options False True 0 True False 12 True 0 none True False 12 3 vertical 3 None True True False True True True Does not apply an operation when you insert the cell range from the clipboard. The contents of the clipboard will replace existing cell contents. False True 0 Add True True False True True none Adds the values in the clipboard cells to the values in the target cells. Also, if the clipboard only contains comments, adds the comments to the target cells. False True 1 Subtract True True False True True none Subtracts the values in the clipboard cells from the values in the target cells. False True 2 Multiply True True False True True none Multiplies the values in the clipboard cells with the values in the target cells. False True 3 Divide True True False True True none Divides the values in the target cells by the values in the clipboard cells. False True 4 True False Operations False True 1 2 0 False True 2 ok cancel help Inserts the contents of the clipboard into the current file in a format that you can specify.