A feature that allows you to paste specific elements of copied data, such as values, formulas, or formatting, rather than the entire cell content.
Mit KI ausprobierenPaste Special provides granular control over how data is inserted into a worksheet. It enables users to strip away formatting, convert formulas to static values, perform mathematical operations during the paste, or transpose rows and columns.
If you copy a cell containing a formula but only want the result, use Paste Special > Values to paste the static number instead of the formula.
You can access it by right-clicking a cell after copying, or by using the keyboard shortcut Ctrl + Alt + V.