Microsoft Office Tutorials and References
In Depth Information
Accessing the Paste Options Gallery from the Paste Drop-Down
Why Keyboard-Centric People Like the Context Gallery
Why Keyboard-Centric People Like the Context Gallery
I am not a right-click person. I always use keyboard shortcuts in-
stead of the mouse. I can press Alt+E+S+V+Enter before most people
can even move their hand over to the mouse.
Take a close look at your keyboard. To the left of the spacebar,
between the FN and Alt keys, do you have the Flying Windows key?
I ve memorized a few of its shortcuts, such as Win+E to open Windows
Explorer. Now, look over to the right of the spacebar. What do you
have between Alt and Ctrl there? I have a key that I had never used
before today. This key looks like the right-click menu and is the Con-
text Menu key. When I press that key in Excel, the right-click menu ap-
pears in the worksheet.
Those six icons in the Paste Options gallery in the right-click menu
each have a keyboard accelerator:
P Normal Paste
V Paste Values
F Formulas
T Transpose
R Formats
N Paste Link
This means that there is an even faster keyboard method for con-
verting formulas to values. Press Ctrl+C to copy, press the Context
Menu key, and then press V to convert to values. You probably have
to use two hands: Ctrl+C with the left hand, Context Menu key with
the right hand, and V with the left hand. It takes a little practice until
this is as fast as Ctrl+C, Ctrl+V, Ctrl, V, but it is worth a shot if
you rely on keyboard shortcuts to speed your way through tasks.
Accessing the Paste Options Gallery from the Paste Drop-Down
The Paste Options gallery also appears when you open the Paste drop-down
on the Home tab. Figure 3.31 shows the menu there.
Search JabSto ::




Custom Search