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.

Comments

  1. says

    Hello,I check your blogs named “How to Quickly Copy Values Without Formulas in Excel? – Excel How To” regularly.Your writing style is witty, keep up the good work! And you can look our website about تحميل مهرجانات.

Leave a Reply

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