Ask Your Question

how can I copy a cell from one sheet to another without the formatting

asked 2021-01-02 17:39:08 +0200

I want to copy numbers from a row from one sheet to another without the cell formatting.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-01-02 18:02:12 +0200

Opaque gravatar image

updated 2021-01-02 18:07:10 +0200


  • Copy as usual (CTRL+C)
  • Edit -> Paste -> Paste Special -> Paste Special... (or use CTRL+SHIFT+V) and select what you want to insert by setting the proper options (see screenshot)
  • Click OK

image description

You may also use this alternative procedure:

  • Copy as usual (CTRL+C)
  • Move to target sheet and cell
  • Rightclick -> Paste Special -> Number (or whatever type your data is)

Hope that helps

edit flag offensive delete link more


that's great and it worked. thanks so much! Wished I would have found this site sooner...

Peterschur49 gravatar imagePeterschur49 ( 2021-01-03 15:34:43 +0200 )edit

If it is helpful please consider to click the check mark (✔) next to the answer. Thanks in advance ...

Opaque gravatar imageOpaque ( 2021-01-03 15:46:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-01-02 17:39:08 +0200

Seen: 15 times

Last updated: Jan 02