Ask a new question

Copy/Paste/Special using iPad

I cannot locate any command available to do this. I have a lot of heavily formatted sheets that are getting messed up because I haven't found a way to get formulas and values into cells without bringing in the format of the copied cells. 

Answer
Answer

Hello Tony,

Welcome to Microsoft Community and thank you for posting your query.

I suggest you to refer to the below mentioned steps and check if it helps.

  • To copy an entire formula from a cell:

  • Select the cell in Excel file, then tap Copy.

  • Now, select the cell where you want to paste the formula, then tap Paste.

  • Tap Paste Formulas.

  • To copy and paste only the value of a cell without copying formula.

  • You may copy only the result of a formula cell and paste it to another cell.

  • Select the cell, then tap Copy.

  • Now, select the cell where you want to paste the formula, then tap Paste.

  • Tap Paste Values.

 

I hope the above information helps. Let us know if you need further assistance.

Thank you.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated December 6, 2022 Views 2,241 Applies to: