Copy, paste and Paste Special

Updated November 13, 2026

Copy and paste

  1. Select cells and choose Home › Copy (Ctrl+C) or Cut (Ctrl+X).
  2. Click where they go and choose Home › Paste (Ctrl+V).

Paste into a larger selection and the copied cells repeat to fill it. Copy one cell and paste it into a range to fill the whole range.

Paste only part of it

  1. Copy the cells.
  2. Choose Home › Paste special (Ctrl+Alt+V).
  3. Pick what to paste: All, Formulas, Values, Formats, Comments and Notes, Column widths, and more. Turn on Transpose to turn rows into columns. Then choose OK.

Copy formatting

  • Select a formatted cell, choose Home › Format painter, then click or drag over the cells to format.

If something goes wrong

  • Paste does nothing in the browser. Your browser may ask for permission to read the clipboard. Allow it, or press Ctrl+V (⌘V on a Mac) instead of using the button.

Was this article helpful?