A feature that allows you to paste specific elements of copied data, such as values, formulas, or formatting, rather than the entire cell content.
Try it with AIPaste 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.