Re: Keyboard Shortcuts
- From: CyberTaz <onlygeneraltaz1@xxxxxxxxxxxx>
- Date: Sat, 22 Jul 2006 11:30:14 -0400
On 7/22/06 10:38 AM, in article uo416xZrGHA.4004@xxxxxxxxxxxxxxxxxxxx, "Jay"
<zeugma@xxxxxxxxxxxxxx> wrote:
CyberTaz wrote:
On 7/21/06 5:40 PM, in article uMopa5QrGHA.1140@xxxxxxxxxxxxxxxxxxxx, "Jay"
<zeugma@xxxxxxxxxxxxxx> wrote:
Priyanka Singhal wrote:
Hi Jay,Hi Priyanka,
Will it be useful at all if you were able to assign shortcut to the menu
item yourself ??
try this:
1. Click View | Toolbars| Customize toolbars/Menus
on the commands tab click keyboard
2. Select category: Edit
command : Paste Special
3. Click in "press new shortcut key" and press the shortcut that you want
4. Click Add and OK
Now you have a custom shortcut that brings up paste special dialog.
Thanks,
Priyanka
---------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
That doesn't seem to be an option as it doesn't allow for the assignment
of shortcuts for the actual paste special options:- values, formulas,
formats, transpose etc.
Ideally I want the facility to actually do the paste special via the
keyboard, rather than just invoke the past special menu, which is what
your suggestion would do.
Cheers
-JAY-
Apparently you didn't bother to look beyond the one specific entry in the
list of commands - Paste Values & Paste Formatting are there waiting for a
keystroke to be assigned.
Also if you follow Priyanka's suggestion, once into the Paste Special dialog
you can simply type the appropriate character to select (almost any of) the
options, then press [return]. You actually wind up with fewer keystrokes per
command than the equivalent series of strokes on the PC.
Paste Special>Formats:
Mac = Control+V
PC = Alt+E,S,V,Enter
Or, if you assign Control+P to Paste Special...
Paste Special>Formulas:
Mac = Control+V,V,[return]
PC = Alt+E,S,V,Enter
Granted most of this isn't very well documented, but just because it doesn't
jump up & bite you doesn't mean it isn't there.
HTH |:>)
Bob Jones
[MVP] Office:Mac
Oops. Thanks for that Bob (I'll consider myself told :-)
I wasn't even aware that you could type the characters to select the
options (i.e v for values). Because the letters aren't underlined like
on the PC I thought the facility wasn't available. I suppose this
probably goes for other things too.
Thanks for enlightening me.
-Jay-
Hello Again, Jay -
Glad the insights are useful to you! Sorry if I came off a little stern, but
I was just in a bit of a rush at the time.
Having worked both sides of the street for quite a few years I've come to
understand that the differences really aren't 'monumental' - it's usually
just a matter of how receptive any individual is to making the adjustment.
As mentioned though, many of the similarities just aren't well documented if
documented at all. The objective fact though is that there definitely *are*
differences but it's the user who determines whether the individual
difference is better/worse.
Actually, the underscore thing was a part of Mac OS quite some time ago but
got dropped somewhere along the line. There's still a macro floating around
out there that enables main menu access from the keyboard, but I've never
used it - I'm a dedicated mouser :)
There are also a number of 3rd party utilities that expand on keyboard
access if you're interested - you might try VersionTracker.com or some of
the other software sites for more info.
In the meantime don't hesitate to post any curiosities - I'm sure someone
will be able to offer a solution.
Regards |:>)
Bob Jones
[MVP] Office:Mac
.
- References:
- Keyboard Shortcuts
- From: Jay
- Re: Keyboard Shortcuts
- From: Priyanka Singhal
- Re: Keyboard Shortcuts
- From: Jay
- Re: Keyboard Shortcuts
- From: CyberTaz
- Re: Keyboard Shortcuts
- From: Jay
- Keyboard Shortcuts
- Prev by Date: Re: Keyboard Shortcuts
- Next by Date: hyperlinks won't work
- Previous by thread: Re: Keyboard Shortcuts
- Next by thread: hyperlinks won't work
- Index(es):
Relevant Pages
|