Copy, paste and Paste Special
Updated November 13, 2026
Copy and paste
- Select cells and choose Home › Copy (Ctrl+C) or Cut (Ctrl+X).
- 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
- Copy the cells.
- Choose Home › Paste special (Ctrl+Alt+V).
- 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.