Skip to main content

How to Quickly Copy Values Without Formulas in Excel?

This article will guide you to quickly copy values without formulas in Excel. The example may be easier to understand if you copy A1:C5 to a blank worksheet.

1
2
3
4
5
A B C
Data Formula Result
3 =A2-1
4 =A3-1
5 =A4-1
6 =A5-1

Step 1: Select B2
Step 2: Press and hold CTRL then Select B3:B5
Step 3: Press CTRL C
Step 4: Select a blank cell (eg. C2) and Press CTRL V to paste the values.

This tip is very useful if you use Excel 2003.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>