24. Excel Tips - Pasting values
Why is there no easy way to paste values in Excel ?.. huh, huh.
If I got a pound for every time I had to paste values in Excel, it wld be worth at least 7 EUROs, and I'd be a Zillionaire in Zimbabwean dollars.
The best way of performing this operation known to man is the following:
Step1:
Select range to copy, and press CTRL + C
Step2:
Select the place you want want to paste to, and press the following keys in order:
ALT then e then s then v then ENTER
..there are other ways using the mouse but ExcelExperts prefer to use the keyboard for everything. (Take note Mr Ribbon Designer)
Pasting values - Video Training
- Nick's blog
- Login or register to post comments
- 6336 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago