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:
Select range to copy, and press CTRL + C
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