You can 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.
The example may be easier to understand if you copy A1:C5 to a blank worksheet.
| A | B | C | |
| 1 | Data | Formula | Result |
| 2 | 3 | =A2-1 | |
| 3 | 4 | =A3-1 | |
| 4 | 5 | =A4-1 | |
| 5 | 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.
No comments:
Post a Comment