Monday, February 20, 2017

Is there a shortcut for pasting values only?

Is there a shortcut for pasting values only?

Excel Online doesn't provide a shortcut for pasting calculated values without their formula. However, here's a quick way to copy and paste values:

  1. Select the cell or cell range containing the values and press Ctrl+C.

  2. Select the cell or cell range where you want to paste the values, and click Paste > Paste Values.

Paste values only button under Paste

More about copying and pasting data and using shortcuts

For news about the latest Excel Online updates, visit the Microsoft Excel blog.

No comments:

Post a Comment