Saturday, May 28, 2016

Smart View Ribbon Keyboard Equivalents - Excel 2016

Published in the Smart View for Office Accessibility Guide is a handy table with all of keyboard shortcuts (Smart View Keyboard Equivalents). This is for those of you that either a still suffering from Essbase Add-in withdrawl or you are a Smart View for Office guru that would rather use the keyboard and not have to rely on the mouse.

http://docs.oracle.com/cd/E72988_01/AGSMV/smart_view_accessibility.html#sv_accessibility_83

http://docs.oracle.com/cd/E72988_01/AGSMV/smart_view_accessibility.html#sv_user_book_24

All Smart View Data Providers and multiple versions of Office; 2007, 2010, 2013 & 2016


This is the list that I use the most, in Excel, since recently getting an upgrade to Office 2016.

Smart View Ribbon Keyboard Equivalents for Excel 2016
Table 4. Smart View Ribbon Keyboard Equivalents for Excel 2016 (assumes Smart View ribbon is Alt+S)



Keys Action
Alt+S Display Smart View ribbon
Alt+S+P Panel
Alt+S+C Connections
Alt+S+C+T Connections, Active Connections
Alt+S+C+E Connections, Reset to Default Connection
Alt+S+C+O Connections, Reporting and Analysis Document
Alt+S+C+O+E Connections, Reporting and Analysis Document, Edit
Alt+S+C+O+C Connections, Reporting and Analysis Document, Edit Connection
Alt+S+C+U Connections, Recently Used
Alt+S+E+N Undo
Alt+S+E+D Redo
Alt+S+E+C Copy
Alt+S+E+V Paste
Alt+S+U Functions
Alt+S+U+M Functions, Manage POV
Alt+S+U+B Functions, Build Function
Alt+S+U+F Functions, Fix Links
Alt+S+U+Z Functions, Visualize
Alt+S+U+Z+E Functions, Visualize, Excel
Alt+S+Y+3+R Refresh, Refresh
Alt+S+Y+3+A Refresh, Replace and Refresh
Alt+S+Y+3+S Refresh, Refresh All Worksheets
Alt+S+Y+4 Submit Data
Alt+S+S Options
Alt+S+H Help
Alt+S+H+C Help, Contents
Alt+S+H+P Help, Oracle User Productivity Kit
Alt+S+H+S Help, Technical Support
Alt+S+H+D Help, Documentation
Alt+S+H+Z Help, About
Alt+S+F Sheet Info
Alt+S+R+M More
Alt+S+R+M+G More, Migrate Active Workbook (Financial Management)
Alt+S+R+M+B More, Migrate Batch (Financial Management)
Alt+S+R+M+R More, Migrate Active Workbook (Hyperion Enterprise)
Alt+S+R+M+E More, Migrate Batch (Hyperion Enterprise)
Alt+S+R+M+I More, Insert Connection List
Alt+S+R+M+P More, Import Metadata
Alt+S+Y+4, if not connected to data source Start Diagnostics; Stop Diagnostics
Alt+S+Y+5, when connected to data source Start Diagnostics; Stop Diagnostics
Alt+S+Y+5, if not connected to data source Clear Diagnostics Folder
Alt+S+Y+6, when connected to data source Clear Diagnostics Folder
Alt+S+Y+6, if not connected to data source Take Screenshot
Alt+S+Y+7 when connected to data source Take Screenshot
Alt+S+Y+7, if not connected to data source Create Archive
Alt+S+Y+8, when connected to data source Create Archive
Alt+S+Y+8, if not connected to data source Diagnostics Options
Alt+S+Y+9 Diagnostics Options
Alt+S+Y+9, if not connected to data source Save Document
Alt+S+Y+Y+A, when connected to data source Save Document
 


No comments:

Post a Comment