I hear a lot of discussion and sometime complaints about what shortcut keys do or do not exist for Smart View and being a ‘mouse’ centric guy I really never paid much attention. Recently I saw a demo of the Ribbon interface where someone explained the model Office used for Keyboard shortcuts and I took notice. I took notice because basically you can do anything you want in Smart View with keyboard shortcuts and you can customize some of your favorites to be really quick and easy.
To get really familiar with keyboard shortcut you need to start by understanding what Office give us for free. Frankly Smart View does not do anything special here, we are simply leveraging the ribbon and just get this stuff.
http://office2010.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx
This applies to Office 2007 and Office 2010 because this is where the ribbon is available. It will also apply better to more recent releases of Smart View where we have heavily integrated with the Office ribbon.
The magic key to remember is the ‘ALT’ key. Open Office and press the ‘ALT’ and all the shortcuts in Office will be revealed even for Smart View.
ALT-S activates the Smart View ribbon and once I have a specific query in play I can also activate my provider specific ribbons. ALT-Y-AZ-N does a zoom in on an Essbase Ad-Hoc query.
o
I know that is a lot of key strokes! And the key to making this useful is the Office Quick Access toolbar. Any item you place in this toolbar get a simple shortcut key. I added zoom-in an refresh among other items to this toolbar and in the picture below you see the much simpler shortcut keys.
ALT-7 for Refresh and ALT-8 for Zoom-In.
I hope this helps all you keyboard junkies out there! I, however easy this is, will stick with the mouse…
1 comments:
The piece about adding them to the shorcut bar is what got my attention. Doing that makes the keystrokes easy, otherwise, I don't know that you save a lot with so many keystrokes. As always thanks for good information
Post a Comment