Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to copy and paste content from one sheet to another sheet within the same file, keeping formulas where there are formulas, and keeping data where there is just data.

I tested every "paste special option" and none seem to do this. Any suggestions?

share|improve this question
Have you tried to Paste special under Edit in the menu? – Jacob Jan Tuinstra Jun 1 '13 at 19:17
"I tested every past special option and non seem to do this" – Rod Lloyd Jun 1 '13 at 19:34
IF you could share your sheet with us and give us more detail on exactly what you are trying to do, it would help us get to a solution much faster. – William Jun 6 '13 at 16:48

Don't use past special, just Ctrl+c and Ctrl+v should serve.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.