It’s particularly annoying because it’s too late once you’ve pressed the arrow key to easily undo the additional cell reference that has been added. The solution is to press F2 before using the arrow keys. This brings the dialog box into edit mode and you can happily use your arrow keys just like you would when editing a cell. We can tell when the dialog box is in edit mode because it will say so in the bottom left of the status bar. Pro tip 2: Paste Values ALT > E > S > V > Enter Note: This applies to all dialog boxes, not just for charts. One of the most common tasks is copying and pasting. We all know the keyboard shortcut for copy is CTRL+C and paste is CTRL+V.
However, one of the most common paste tasks I perform is Paste Values. The official keyboard shortcut for Paste Values is CTRL+ALT+V > V > ENTER.
I don’t know about you, but I reckon you need to be a contortionist to press CTRL+ALT+V with one hand, after all, the other hand is still on the mouse…just because we’re pro Excel users doesn’t mean we’re foolish enough to throw away the mouse. Therefore, the original keyboard shortcut ALT > E > S > V > Enter (i.e. one key at a time and lowercase is fine) is far easier. You can do it with one hand and even if you can’t touch type, after a few practices you don’t need to look at the keyboard.
0 kommentar(er)
