Excel Keyboard Shortcuts in the Paste Special Dialog box

  1. Paste all cell contents and formatting.
    A
  2. Paste only the formulas as entered in the formula bar.
    F
  3. Paste only the values (not the formulas).
    V
  4. Paste only the copied formatting.
    T
  5. Paste only comments and notes attached to the cell.
    C
  6. Paste only the data validation settings from copied cells.
    N
  7. Paste all cell contents and formatting from copied cells.
    H
  8. Paste all cell contents without borders.
    X
  9. Paste only column widths from copied cells.
    W
  10. Paste only formulas and number formats from copied cells.
    R
  11. Paste only the values (not formulas) and number formats from copied cells.
    U
Author
egf4201
ID
350275
Card Set
Excel Keyboard Shortcuts in the Paste Special Dialog box
Description
Excel Keyboard Shortcuts in the Paste Special Dialog box
Updated