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.
|
|
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.