Oracle® Smart View for Office

Accessibility Guide

Release 11.1.2.5.500

Copyright © 2004, 2015, Oracle and/or its affiliates. All rights reserved.

Authors: EPM Information Development Team

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS:

Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Table of Contents:

Enabling Accessibility for Smart View

Smart View Keyboard Equivalents

Installing and Configuring Help Locally

This document describes the accessibility features of Oracle Smart View for Office. For information regarding supported assistive technologies, refer to the Oracle Enterprise Performance Management System Installation Start Here.

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program web site at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Enabling Accessibility for Smart View

You do not need to enable accessibility specifically for Smart View; it is always in accessible mode. Smart View output is in the form of Excel spreadsheets, Word documents, and PowerPoint slides, which are accessible through Microsoft Office. For information about Excel, Word, or PowerPoint accessibility, refer to Microsoft Office product documentation.

Note:

If you are using JAWS® Screen Reading Software, Oracle recommends using the Internet Explorer browser.

Enabling JAWS to Read ListView Headers

ListViews display information in a table format within the Smart View user interface. Examples of dialog boxes that display information in the ListView format are Select Forms or Manage Journals.

ListView headers are the column headings within a ListView. By default, JAWS does not read the ListView headers; however, you can enable JAWS to read them.

  To enable JAWS to read ListView headers:

  1. Ensure that JAWS is running.

  2. Within a ListView, select a row containing data, then press Insert+F2.

  3. In the Run JAWS Manager dialog box, select Customize ListView and press Enter.

    The Customize Headers dialog box is displayed

  4. In the Column Headers group, select the Speak Custom Text AND Header option.

  5. Click OK to save the changes.

    JAWS should begin speaking the column headers in the ListView element. If this doesn't happen, restart the Office application.

Smart View Keyboard Equivalents

Keyboard equivalents for provider ribbons may vary if other Office add-ins or extensions are installed. For example, Y may become Y1 or Y2 if there are ribbons created by add-ins in addition to Smart View.

Keyboard equivalents for languages other than English may be different from those listed in these tables.

The topics in this section describes the keyboard equivalents for the following:

Smart View Ribbon Keyboard Equivalents

Subtopics

The tables in this section list Smart View ribbon items.

Smart View Ribbon Keyboard Equivalents for Excel 2007

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

KeysAction
Alt+SDisplay Smart View ribbon
Alt+S+PPanel
Alt+S+C+1Connections
Alt+S+C+TConnections, Active Connections
Alt+S+C+EConnections, Reset to Default Connection
Alt+S+C+OConnections, Reporting and Analysis Document
Alt+S+C+O+EConnections, Reporting and Analysis Document, Edit
Alt+S+C+O+CConnections, Reporting and Analysis Document, Edit Connection
Alt+S+C+UConnections, Recently Used
Alt+S+E+NUndo
Alt+S+E+DRedo
Alt+S+E+CCopy
Alt+S+E+VPaste
Alt+S+UFunctions
Alt+S+U+MFunctions, Manage POV
Alt+S+U+BFunctions, Build Function
Alt+S+U+FFunctions, Fix Links
Alt+S+U+ZFunctions, Visualize
Alt+S+U+Z+EFunctions, Visualize, Excel
Alt+S+D+R+RRefresh, Refresh
Alt+S+D+R+ARefresh, Replace and Refresh
Alt+S+D+R+SRefresh, Refresh All Worksheets
Alt+S+D+S+1Submit Data
Alt+S+SOptions
Alt+S+HHelp
Alt+S+H+CHelp, Contents
Alt+S+H+PHelp, Oracle User Productivity Kit
Alt+S+H+SHelp, Technical Support
Alt+S+H+EHelp, EPM Documentation
Alt+S+H+ZHelp, About
Alt+S+FSheet Info
Alt+S+R+MMore
Alt+S+R+M+GMore, Migrate Active Workbook (Financial Management)
Alt+S+R+M+BMore, Migrate Batch (Financial Management)
Alt+S+R+M+RMore, Migrate Active Workbook (Hyperion Enterprise)
Alt+S+R+M+EMore, Migrate Batch (Hyperion Enterprise)
Alt+S+R+M+IMore, Insert Connection List
Alt+S+R+M+PMore, Import Metadata
Alt+S+D+S+2Start Diagnostics; Stop Diagnostics
Alt+S+D+CClear Diagnostics Folder
Alt+S+D+TTake Screenshot
Alt+S+D+ACreate Archive
Alt+S+D+ODiagnostics Options
Alt+S+D+1Save Document

Smart View Ribbon Keyboard Equivalents for Excel 2010

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

KeysAction
Alt+SDisplay Smart View ribbon
Alt+S+PPanel
Alt+S+CConnections
Alt+S+C+TConnections, Active Connections
Alt+S+C+EConnections, Reset to Default Connection
Alt+S+C+OConnections, Reporting and Analysis Document
Alt+S+C+O+EConnections, Reporting and Analysis Document, Edit
Alt+S+C+O+CConnections, Reporting and Analysis Document, Edit Connection
Alt+S+C+UConnections, Recently Used
Alt+S+Y+E+NUndo
Alt+S+Y+E+DRedo
Alt+S+Y+E+CCopy
Alt+S+Y+E+VPaste
Alt+S+UFunctions
Alt+S+U+MFunctions, Manage POV
Alt+S+U+BFunctions, Build Function
Alt+S+U+FFunctions, Fix Links
Alt+S+U+ZFunctions, Visualize
Alt+S+U+Z+EFunctions, Visualize, Excel
Alt+S+Y+2+RRefresh, Refresh
Alt+S+Y+2+ARefresh, Replace and Refresh
Alt+S+Y+2+SRefresh, Refresh All Worksheets
Alt+S+Y+3Submit Data
Alt+S+SOptions
Alt+S+HHelp
Alt+S+H+CHelp, Contents
Alt+S+H+PHelp, Oracle User Productivity Kit
Alt+S+H+SHelp, Technical Support
Alt+S+H+DHelp, EPM Documentation
Alt+S+H+ZHelp, About
Alt+S+FSheet Info
Alt+S+R+MMore
Alt+S+R+M+GMore, Migrate Active Workbook (Financial Management)
Alt+S+R+M+BMore, Migrate Batch (Financial Management)
Alt+S+R+M+RMore, Migrate Active Workbook (Hyperion Enterprise)
Alt+S+R+M+EMore, Migrate Batch (Hyperion Enterprise)
Alt+S+R+M+IMore, Insert Connection List
Alt+S+R+M+PMore, Import Metadata
Alt+S+Y+3, if not connected to data source

Alt+S+Y+4, when connected to data source

Start Diagnostics; Stop Diagnostics
Alt+S+Y+4, if not connected to data source

Alt+S+Y+5, when connected to data source

Clear Diagnostics Folder
Alt+S+Y+5, if not connected to data source

Alt+S+Y+6, when connected to data source

Take Screenshot
Alt+S+Y+6, if not connected to data source

Alt+S+Y+7, when connected to data source

Create Archive
Alt+S+Y+7, if not connected to data source

Alt+S+Y+8, when connected to data source

Diagnostics Options
Alt+S+Y+8, if not connected to data source

Alt+S+Y+9, when connected to data source

Save Document

Smart View Ribbon Keyboard Equivalents for Excel 2013

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

KeysAction
Alt+SDisplay Smart View ribbon
Alt+S+PPanel
Alt+S+CConnections
Alt+S+C+TConnections, Active Connections
Alt+S+C+EConnections, Reset to Default Connection
Alt+S+C+OConnections, Reporting and Analysis Document
Alt+S+C+O+EConnections, Reporting and Analysis Document, Edit
Alt+S+C+O+CConnections, Reporting and Analysis Document, Edit Connection
Alt+S+C+UConnections, Recently Used
Alt+S+E+NUndo
Alt+S+E+DRedo
Alt+S+E+CCopy
Alt+S+E+VPaste
Alt+S+UFunctions
Alt+S+U+MFunctions, Manage POV
Alt+S+U+BFunctions, Build Function
Alt+S+U+FFunctions, Fix Links
Alt+S+U+ZFunctions, Visualize
Alt+S+U+Z+EFunctions, Visualize, Excel
Alt+S+Y+2+RRefresh, Refresh
Alt+S+Y+2+ARefresh, Replace and Refresh
Alt+S+Y+2+SRefresh, Refresh All Worksheets
Alt+S+Y+3Submit Data
Alt+S+SOptions
Alt+S+HHelp
Alt+S+H+CHelp, Contents
Alt+S+H+PHelp, Oracle User Productivity Kit
Alt+S+H+SHelp, Technical Support
Alt+S+H+EHelp, EPM Documentation
Alt+S+H+ZHelp, About
Alt+S+FSheet Info
Alt+S+R+MMore
Alt+S+R+M+GMore, Migrate Active Workbook (Financial Management)
Alt+S+R+M+BMore, Migrate Batch (Financial Management)
Alt+S+R+M+RMore, Migrate Active Workbook (Hyperion Enterprise)
Alt+S+R+M+EMore, Migrate Batch (Hyperion Enterprise)
Alt+S+R+M+IMore, Insert Connection List
Alt+S+R+M+PMore, Import Metadata
Alt+S+Y+3, if not connected to data source

Alt+S+Y+4, when connected to data source

Start Diagnostics; Stop Diagnostics
Alt+S+Y+4, if not connected to data source

Alt+S+Y+5, when connected to data source

Clear Diagnostics Folder
Alt+S+Y+5, if not connected to data source

Alt+S+Y+6, when connected to data source

Take Screenshot
Alt+S+Y+6, if not connected to data source

Alt+S+Y+7, when connected to data source

Create Archive
Alt+S+Y+7, if not connected to data source

Alt+S+Y+8

Diagnostics Options
Alt+S+Y+8, if not connected to data source

Alt+S+Y+9, when connected to data source

Save Document

Smart View Ribbon Keyboard Equivalents for Word and PowerPoint 2007

Table 4. Smart View Ribbon Keyboard Equivalents for Word and PowerPoint 2007 (assumes Smart View ribbon is Alt+S+2)

KeysAction
Alt+S+2Display Smart View ribbon
Alt+S+2+PPanel
Alt+S+2+CConnections
Alt+S+2+C+OConnections, Reporting and Analysis Document
Alt+S+2+C+O+CConnections, Reporting and Analysis Document, Create Template
Alt+S+2+C+O+RConnections, Reporting and Analysis Document, Refresh Template
Alt+S+2+C+O+EConnections, Reporting and Analysis Document, Edit
Alt+S+2+C+O+CConnections, Reporting and Analysis Document, Edit Connection
Alt+S+2+C+UConnections, Recently Used
Alt+S+2+E+CCopy Data Point
Alt+S+2+E+VPaste Data Point
Alt+S+2+E+MManage POV
Alt+S+2+D+R+RRefresh, Refresh
Alt+S+2+D+R+ARefresh, Replace and Refresh
Alt+S+2+D+R+SRefresh, Refresh All Slides
Alt+S+2+D+EVisualize in Excel
Alt+S+2+SOptions
Alt+S+2+HHelp
Alt+S+2+H+CHelp, Contents
Alt+S+2+H+PHelp, Oracle User Productivity Kit
Alt+S+2+H+SHelp, Technical Support
Alt+S+2+H+EHelp, EPM Documentation
Alt+S+2+H+ZHelp, About
Alt+S+2+D+SStart Diagnostics; Stop Diagnostics
Alt+S+2+D+CClear Diagnostics Folder
Alt+S+2+D+TTake Screenshot
Alt+S+2+D+ACreate Archive
Alt+S+2+D+ODiagnostics Options
Alt+S+2+D+1Save Document

Smart View Ribbon Keyboard Equivalents for Word and PowerPoint 2010 and 2013

Table 5. Smart View Ribbon Keyboard Equivalents for Word and PowerPoint 2010 and 2013 (assumes Smart View ribbon is Alt+Y+1)

KeysAction
Alt+Y+1Display Smart View ribbon
Alt+Y+1+PPanel
Alt+Y+1+CConnections
Alt+Y+1+C+OConnections, Reporting and Analysis Document
Alt+Y+1+C+O+CConnections, Reporting and Analysis Document, Create Template
Alt+Y+1+C+O+RConnections, Reporting and Analysis Document, Refresh Template
Alt+Y+1+C+O+EConnections, Reporting and Analysis Document, Edit
Alt+Y+1+C+O+CConnections, Reporting and Analysis Document, Edit Connection
Alt+Y+1+C+UConnections, Recently Used
Alt+Y+1+Y+2Copy
Alt+Y+1+Y+3Paste Data Point
Alt+Y+1+Y+4Manage POV
Alt+Y+1+Y+5+RRefresh
Alt+Y+1+Y+5+ARefresh, Replace and Refresh
Alt+Y+1+Y+5+SRefresh, Replace All Slides (PowerPoint 2010, 2013)
Alt+Y+1+Y+6Visualize in Excel
Alt+Y+1+SOptions
Alt+Y+1+HHelp
Alt+Y+1+H+CHelp, Contents
Alt+Y+1+H+PHelp, Oracle User Productivity Kit
Alt+Y+1+H+SHelp, Technical Support
Alt+Y+1+H+EHelp, EPM Documentation
Alt+Y+1+H+ZHelp, About
Alt+Y+1+Y+AStart Diagnostics; Stop Diagnostics (Word)
Alt+Y+1+Y+7Start Diagnostics; Stop Diagnostics (PowerPoint)
Alt+Y+1+Y+BClear Diagnostics Folder (Word)
Alt+Y+1+Y+8Clear Diagnostics Folder (PowerPoint)
Alt+Y+1+Y+CTake Screenshot (Word)
Alt+Y+1+Y+9Take Screenshot (PowerPoint
Alt+Y+1+Y+DCreate Archive (Word)
Alt+Y+1+Y+ACreate Archive (PowerPoint)
Alt+Y+1+Y+EDiagnostics Options (Word)
Alt+Y+1+Y+BDiagnostics Options (PowerPoint)
Alt+Y+1+Y+FSave Document (Word)
Alt+Y+1+Y+CSave Document (PowerPoint)

Office 2007 Data Provider Keyboard Equivalents

Subtopics

The tables in this section list ribbon items for Office 2007.

Exceptions are noted in parentheses.

Data Provider Ribbon Keyboard Equivalents for Excel 2007

Table 6. Data Provider Ribbon Keyboard Equivalents for Excel 2007 (assumes provider ribbon is Alt+Y)

KeysAction
Alt+Y+YAnalyze (Planning only)
Alt+Y+D+RRefresh
Alt+Y+D+R+RRefresh, Refresh
Alt+Y+D+R+SRefresh, Refresh All
Alt+Y+D+ODisplay or Hide POV
Alt+Y+D+DDrill-through
Alt+Y+A+MAdd Member
Alt+Y+D+BSubmit Data
Alt+Y+D+ECell Comments (HFM only)
Alt+Y+D+A+ECell Comments (Planning only)
Alt+Y+D+PSupporting Detail (Planning only)
Alt+Y+D+TDocument Attachment (Planning only)
Alt+Y+D+LLock (Planning only)
Alt+Y+D+CCalculate
Alt+Y+D+C+BCalculate, Business Rules (Planning only)
Alt+Y+D+C+UCalculate, Rules on Form (Planning only)
Alt+Y+D+C+DCalculate, Calculate
Alt+Y+D+C+FCalculate, Force Calculate (HFM and Enterprise only)
Alt+Y+D+C+TCalculate, Translate (HFM and Enterprise only)
Alt+Y+D+C+RCalculate, Force Translate (HFM and Enterprise only)
Alt+Y+D+O+2Consolidate (HFM and Enterprise only)
Alt+Y+D+O+2+NConsolidate, Consolidate (HFM and Enterprise only)
Alt+Y+D+O+2+SConsolidate, Consolidate All (HFM and Enterprise only)
Alt+Y+D+O+2+LConsolidate, Consolidate All With Data (HFM and Enterprise only)
Alt+Y+D+O+2+AConsolidate, Calculate Contribution (HFM and Enterprise only)
Alt+Y+D+O+2+OConsolidate, Force Calculate Contribution (HFM only)
Alt+Y+WView Comments
Alt+Y+D+UAdjust
Alt+Y+D+U+JAdjust, Adjust
Alt+Y+D+U+GAdjust, Grid Spread (Planning only)
Alt+Y+D+U+AAdjust, Mass Allocate (Planning only)
Alt+Y+D+DDrill-through
Alt+Y+IInstructions (Financial Management only)
Alt+Y+NEntity Details (Financial Management only)
Alt+Y+TCreate Journal (Financial Management only)
Alt+Y+D+MMore (Planning only)
Alt+Y+D+M+JMore, Job Console (Planning only)
Alt+Y+D+M+MMore, Member Formula (Planning only)
Alt+Y+D+M+IMore, Instructions (Planning only)
Alt+Y+D+M+FMore, Offline (Planning only)
Alt+Y+D+M+F+TMore, Offline, Take Offline (Planning only)
Alt+Y+D+M+F+YMore, Offline, Sync Back to Server (Planning only)
Alt+Y+D+M+F+RMore, Offline, Refresh Offline Definition (Planning only)
Alt+Y+SSave Formatting (Planning only)
Alt+Y+CClear Formatting (Planning only)
Alt+Y+AApply Formatting (Planning only)
Alt+Y+A+NApply Formatting, None (Planning only)
Alt+Y+A+YApply Formatting, Cell styles (Planning only)
Alt+Y+A+CApply Formatting, Custom styles (Planning only)
Alt+Y+A+AApply Formatting, Custom and cell styles (Planning only)
Alt+Y+W+PApprovals (Planning only)
Alt+Y+W+VCopy Version (Planning only)

Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2007

Table 7. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2007 (assumes Essbase or ad hoc ribbon is Alt+Y)

KeysAction
Alt+Y+A+ZZoom In
Alt+Y+A+Z+NZoom In, Next Level
Alt+Y+A+Z+AZoom In, All Levels
Alt+Y+A+Z+BZoom In, Bottom Level
Alt+Y+A+Z+EZoom In, Same Level (Essbase only)
Alt+Y+A+Z+LZoom In, Sibling Level (Essbase only)
Alt+Y+A+Z+GZoom In, Same Generation (Essbase only)
Alt+Y+A+Z+FZoom In, Formulas (Essbase only)
Alt+Y+A+UZoom Out
Alt+Y+A+TPivot
Alt+Y+A+T+PPivot, Pivot
Alt+Y+A+T+TPivot, Pivot to POV
Alt+Y+A+KKeep Only
Alt+Y+A+ORemove Only
Alt+Y+A+IMember Selection
Alt+Y+A+QQuery
Alt+Y+A+Q+QQuery, Query Designer
Alt+Y+A+Q+RQuery, Run Report
Alt+Y+A+Q+EQuery, Execute MDX (Essbase only)
Alt+Y+A+Q+DQuery, Data Filter
Alt+Y+A+EMember Information (Essbase only)
Alt+Y+A+PPreserve Format (except Enterprise Ad Hoc)
Alt+Y+A+AChange Alias (Essbase only)
Alt+Y+A+DData Perspective (Essbase only)
Alt+Y+A+SSmart Slice (except Enterprise)
Alt+Y+A+CCascade (except Enterprise Ad Hoc)
Alt+Y+A+C+SCascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+A+C+NCascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+A+C+DCascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+D+RRefresh
Alt+Y+D+R+RRefresh, Refresh
Alt+Y+D+R+ARefresh, Refresh All
Alt+Y+D+OPOV
Alt+Y+D+WView Comments
Alt+Y+D+CCalculate
Alt+Y+D+ZVisualize (Essbase only)
Alt+Y+D+Z+EVisualize, Visualize in Excel (Essbase only)
Alt+Y+NEntity Details (Financial Management only)
Alt+Y+TCreate Journal (Financial Management only)
Alt+Y+D+DDrill-through
Alt+Y+JLinked Objects (Essbase only)
Alt+Y+D+UAdjust
Alt+Y+D+S+BSubmit Data
Alt+Y+D+S+WSubmit Data Without Refresh
Alt+Y+D+S+RSubmit Data Range

Oracle Journals Keyboard Equivalents for Excel 2007

Table 8. Oracle Journals Keyboard Equivalents for Excel 2007 (assumes Oracle Journals ribbon is Alt+J)

KeysAction
Alt+J+AAnalyze
Alt+J+MMember Selection
Alt+J+RRefresh
Alt+J+CScan
Alt+J+OPost
Alt+J+NUnpost
Alt+J+USubmit
Alt+J+IUnsubmit
Alt+J+VApprove
Alt+J+JReject
Alt+J+TStatus
Alt+J+BBalance Type
Alt+J+PType
Alt+J+GGroup
Alt+J+LSecurity Class
Alt+J+EEdit
Alt+J+SSave

Oracle BI EE Ribbon Keyboard Equivalents for Office 2007

Table 9. Oracle BI EE Ribbon Keyboard Equivalents for Office 2007 (assumes Oracle BI EE ribbon is Alt+Y+1)

KeyAction
Alt+Y+1+Y+1View Designer
Alt+Y+1+Y+2Publish View
Alt+Y+1+Y+3Refresh
Alt+Y+1+Y+4Edit Prompts
Alt+Y+1+Y+5Edit Page Prompts
Alt+Y+1+Y+6Copy
Alt+Y+1+Y+7Paste
Alt+Y+1+Y+8Delete
Alt+Y+1+Y+9Mask Data

Enterprise Performance Reporting Keyboard Shortcuts for Excel 2007

Table 10. Enterprise Performance Reporting Keyboard Shortcuts for Excel 2007 (assumes Performance Reporting Ribbon is Alt+Y)

KeysAction
Alt+Y+A+ZZoom In
Alt+Y+A+Z+NZoom In, Next Level
Alt+Y+A+Z+AZoom In, All Levels
Alt+Y+A+Z+BZoom In, Bottom Level
Alt+Y+A+UZoom Out
Alt+Y+A+TPivot
Alt+Y+A+T+PPivot (between rows and columns, or from page dimension cells to grid)
Alt+Y+A+T+TPivot To POV
Alt+Y+A+KKeep Only
Alt+Y+A+ORemove Only
Alt+Y+A+IMember Selection
Alt+Y+A+AChange Alias
Alt+Y+D+RRefresh
Alt+Y+D+R+RRefresh, Refresh
Alt+Y+D+R+SRefresh, Refresh All Worksheets
Alt+Y+D+OPOV (displays the POV toolbar)
Alt+Y+D+ZVisualize
Alt+Y+D+Z+EVisualize in Excel

Enterprise Performance Reporting Keyboard Shortcuts for Word 2007

Table 11. Enterprise Performance Reporting Keyboard Shortcuts for Word 2007 (assumes Performance Reporting Ribbon is Alt+Y)

KeysAction
Author RibbonAuthor Ribbon
Alt+Y+Y+1Check Out
Alt+Y+Y+2Upload
Alt+Y+Y+3Check In
Alt+Y+Y+4Submit
Alt+Y+Y+5Approve
Alt+Y+Y+6Reject
Alt+Y+Y+7Refresh
Alt+Y+Y+8Inspect
Alt+Y+Y+9Sync
Review RibbonReview Ribbon
Alt+Y+Y+1Add New Comment
Alt+Y+Y+2Filter Comments
Alt+Y+Y+3Hide Anchor, Show Anchor
Alt+Y+Y+4Mark Review Complete
Alt+Y+Y+5Refresh Comments
Alt+Y+Y+8Inspect
Alt+Y+Y+9Sync
Sign Off RibbonSign Off Ribbon
Alt+Y+Y+1Sign Off
Alt+Y+Y+2Reject Sign Off
Alt+Y+Y+3Inspect
Alt+Y+Y+4Sync

Office 2010 Data Provider Keyboard Equivalents

Subtopics

The tables in this section list ribbon items for Office 2010.

Exceptions are noted in parentheses.

Data Provider Ribbon Keyboard Equivalents for Excel 2010

Table 12. Data Provider Ribbon Keyboard Equivalents for Excel 2010 (assumes provider ribbon is Alt+Y+1)

KeysAction
Alt+Y+1+Y+2Analyze (Planning only)
Alt+Y+1+D+RRefresh
Alt+Y+1+D+R+R Refresh, Refresh
Alt+Y+1+D+R+ARefresh, Refresh All
Alt+Y+1+D+DDrill-through
Alt+Y+1+A+MAdd Member
Alt+Y+1+D+BSubmit Data
Alt+Y+1+D+ACell Actions
Alt+Y+1+D+ECell Actions, Comments
Alt+Y+1+D+PCell Actions, Supporting Detail (Planning only)
Alt+Y+1+D+TCell Actions, Attachment (Planning only)
Alt+Y+1+D+HCell Actions, History
Alt+Y+1+D+LLock (Planning only)
Alt+Y+1+D+CCalculate
Alt+Y+1+D+C+BCalculate, Business Rules (Planning only)
Alt+Y+1+D+C+UCalculate, Rules on Form (Planning only)
Alt+Y+1+D+C+DCalculate, Calculate
Alt+Y+1+D+C+FCalculate, Force Calculate (HFM and Enterprise only)
Alt+Y+1+D+C+TCalculate, Translate (HFM and Enterprise only)
Alt+Y+1+D+C+RCalculate, Force Translate (HFM and Enterprise only)
Alt+Y+1+D+O+2Consolidate (HFM and Enterprise only)
Alt+Y+1+D+O+2+NConsolidate, Consolidate (HFM and Enterprise only)
Alt+Y+1+D+O+2+SConsolidate, Consolidate All (HFM and Enterprise only)
Alt+Y+1+D+O+2+LConsolidate, Consolidate All With Data (HFM and Enterprise only)
Alt+Y+1+D+O+2+AConsolidate, Calculate Contribution (HFM and Enterprise only)
Alt+Y+1+D+O+2+OConsolidate, Force Calculate Contribution (HFM only)
Alt+Y+1+WView Comments
Alt+Y+1+D+UAdjust
Alt+Y+1+D+U+JAdjust, Adjust
Alt+Y+1+D+U+GAdjust, Grid Spread (Planning only)
Alt+Y+1+D+U+AAdjust, Mass Allocate (Planning only)
Alt+Y+1+D+DDrill-through
Alt+Y+1+IInstructions (Financial Management only)
Alt+Y+1+NEntity Details (Financial Management only)
Alt+Y+1+TCreate Journal (Financial Management only)
Alt+Y+1+D+MMore (Planning only)
Alt+Y+1+D+M+JMore, Job Console (Planning only)
Alt+Y+1+D+M+MMore, Member Formula (Planning only)
Alt+Y+1+D+M+IMore, Instructions (Planning only)
Alt+Y+1+D+M+FMore, Offline (Planning only)
Alt+Y+1+D+M+F+TMore, Offline, Take Offline (Planning only)
Alt+Y+1+D+M+F+YMore, Offline, Sync Back to Server (Planning only)
Alt+Y+1+D+M+F+RMore, Offline, Refresh Offline Definition (Planning only)
Alt+Y+1+SSave Formatting (Planning only)
Alt+Y+1+CClear Formatting (Planning only)
Alt+Y+1+AApply Formatting (Planning only)
Alt+Y+1+A+NApply Formatting, None (Planning only)
Alt+Y+1+A+YApply Formatting, Cell styles (Planning only)
Alt+Y+1+A+CApply Formatting, Custom styles (Planning only)
Alt+Y+1+A+AApply Formatting, Custom and cell styles (Planning only)
Alt+Y+1+Y+4Approvals (Planning only)
Alt+Y+1+Y+5Copy Version (Planning only)

Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2010 32-bit

Table 13. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2010 32-bit (assumes Essbase or ad hoc ribbon is Alt+Y+1)

KeysAction
Alt+Y+1+Y+2Zoom In
Alt+Y+1+Y+2+NZoom In, Next Level
Alt+Y+1+Y+2+AZoom In, All Levels
Alt+Y+1+Y+2+BZoom In, Bottom Level
Alt+Y+1+Y+2+EZoom In, Same Level (Essbase only)
Alt+Y+1+Y+2+LZoom In, Sibling Level (Essbase only)
Alt+Y+1+Y+2+GZoom In, Same Generation (Essbase only)
Alt+Y+1+Y+2+FZoom In, Formulas (Essbase only)
Alt+Y+1+Y+3Zoom Out
Alt+Y+1+Y+4Pivot
Alt+Y+1+Y+4+PPivot, Pivot
Alt+Y+1+Y+4+TPivot, Pivot to POV
Alt+Y+1+Y+5Keep Only
Alt+Y+1+Y+6Remove Only
Alt+Y+1+Y+7Member Selection
Alt+Y+1+Y+8Query
Alt+Y+1+Y+8+QQuery, Query Designer
Alt+Y+1+Y+8+RQuery, Run Report
Alt+Y+1+Y+8+EQuery, Execute MDX (Essbase only)
Alt+Y+1+Y+8+DQuery, Data Filter
Alt+Y+1+Y+9Member Information (Essbase only)
Alt+Y+1+Y+APreserve Format (except Enterprise Ad Hoc)
Alt+Y+1+Y+BChange Alias (Essbase only) (32-bit)
Alt+Y+1+Y+CData Perspective (Essbase only)
Alt+Y+1+Y+DSmart Slice (except Enterprise)
Alt+Y+1+Y+ECascade (except Enterprise Ad Hoc)
Alt+Y+1+Y+E+SCascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+E+NCascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+E+DCascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+1+D+RRefresh
Alt+Y+1+D+R+RRefresh, Refresh
Alt+Y+1+D+R+ARefresh, Refresh All
Alt+Y+1+D+OPOV
Alt+Y+1+D+WView Comments
Alt+Y+1+D+CCalculate
Alt+Y+1+D+ZVisualize (Essbase only)
Alt+Y+1+D+Z+EVisualize, Visualize in Excel (Essbase only)
Alt+Y+1+NEntity Details (Financial Management only)
Alt+Y+1+TCreate Journal (Financial Management only)
Alt+Y+1+D+DDrill-through
Alt+Y+1+JLinked Objects (Essbase only)
Alt+Y+1+D+UAdjust
Alt+Y+1+D+S+BSubmit Data
Alt+Y+1+D+S+WSubmit Data Without Refresh
Alt+Y+1+D+S+RSubmit Data Range

Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2010 64-bit

Table 14. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2010 64-bit (assumes Essbase or ad hoc ribbon is Alt+Y+1)

KeysAction
Alt+Y+1+Y+5Zoom In
Alt+Y+1+Y+5+NZoom In, Next Level
Alt+Y+1+Y+5+AZoom In, All Levels
Alt+Y+1+Y+5+BZoom In, Bottom Level
Alt+Y+1+Y+5+EZoom In, Same Level (Essbase only)
Alt+Y+1+Y+5+LZoom In, Sibling Level (Essbase only)
Alt+Y+1+Y+5+GZoom In, Same Generation (Essbase only)
Alt+Y+1+Y+5+FZoom In, Formulas (Essbase only)
Alt+Y+1+Y+6Zoom Out
Alt+Y+1+Y+7Pivot
Alt+Y+1+Y+7+PPivot, Pivot
Alt+Y+1+Y+7+TPivot, Pivot to POV
Alt+Y+1+Y+8Keep Only
Alt+Y+1+Y+9Remove Only
Alt+Y+1+Y+BMember Selection
Alt+Y+1+Y+BQuery
Alt+Y+1+Y+B+QQuery, Query Designer
Alt+Y+1+Y+B+RQuery, Run Report
Alt+Y+1+Y+B+EQuery, Execute MDX (Essbase only)
Alt+Y+1+Y+B+DQuery, Data Filter
Alt+Y+1+Y+CMember Information (Essbase only)
Alt+Y+1+Y+DPreserve Format (except Enterprise Ad Hoc)
Alt+Y+1+Y+EChange Alias (Essbase only)
Alt+Y+1+Y+FData Perspective (Essbase only)
Alt+Y+1+Y+GSmart Slice (except Enterprise)
Alt+Y+1+Y+HCascade (except Enterprise Ad Hoc)
Alt+Y+1+Y+H+SCascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+H+NCascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+H+DCascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+1+D+RRefresh
Alt+Y+1+D+R+RRefresh, Refresh
Alt+Y+1+D+R+ARefresh, Refresh All
Alt+Y+1+D+OPOV
Alt+Y+1+D+WView Comments
Alt+Y+1+D+CCalculate
Alt+Y+1+D+ZVisualize (Essbase only)
Alt+Y+1+D+Z+EVisualize, Visualize in Excel (Essbase only)
Alt+Y+1+NEntity Details (Financial Management only)
Alt+Y+1+TCreate Journal (Financial Management only)
Alt+Y+1+D+DDrill-through
Alt+Y+1+JLinked Objects (Essbase only)
Alt+Y+1+D+UAdjust
Alt+Y+1+D+BSubmit Data

Oracle Journals Keyboard Equivalents for Excel 2010

Table 15. Oracle Journals Keyboard Equivalents for Excel 2010 (assumes Oracle Journals ribbon is Alt+J)

KeysAction
Alt+J+AAnalyze
Alt+J+MMember Selection
Alt+J+RRefresh
Alt+J+CScan
Alt+J+OPost
Alt+J+NUnpost
Alt+J+USubmit
Alt+J+IUnsubmit
Alt+J+VApprove
Alt+J+JReject
Alt+J+TStatus
Alt+J+BBalance Type
Alt+J+PType
Alt+J+GGroup
Alt+J+LSecurity Class
Alt+J+EEdit
Alt+J+SSave

Oracle BI EE Ribbon Keyboard Equivalents for Office 2010

Table 16. Oracle BI EE Ribbon Keyboard Equivalents for Office 2010 (assumes Oracle BI EE Ribbon is Alt+Y+1)

KeyAction
Alt+Y+1+Y+2View Designer
Alt+Y+1+Y+3Publish View
Alt+Y+1+Y+4Refresh
Alt+Y+1+Y+5Edit Prompts
Alt+Y+1+Y+6Edit Page Prompts
Alt+Y+1+Y+7Copy
Alt+Y+1+Y+8Paste
Alt+Y+1+Y+9Delete
Alt+Y+1+Y+AMask Data

Enterprise Performance Reporting Keyboard Shortcuts for Excel 2010

Table 17. Enterprise Performance Reporting Keyboard Shortcuts for Excel 2010 (assumes Performance Reporting Ribbon is Alt+Y)

KeyAction
Alt+Y+A+ZZoom In
Alt+Y+A+Z+NZoom In, Next Level
Alt+Y+A+Z+AZoom In, All Levels
Alt+Y+A+Z+BZoom In, Bottom Level
Alt+Y+A+UZoom Out
Alt+Y+A+TPivot
Alt+Y+A+T+PPivot (between rows and columns, or from page dimension cells to grid)
Alt+Y+A+T+TPivot to POV
Alt+Y+A+KKeep Only
Alt+Y+A+ORemove Only
Alt+Y+A+IMember Selection
Alt+Y+A+AChange Alias
Alt+Y+D+RRefresh
Alt+Y+D+R+RRefresh, Refresh (current worksheet)
Alt+Y+D+R+SRefresh, Refresh All Worksheets
Alt+Y+D+OPOV (displays the POV toolbar)
Alt+Y+D+ZVisualize
Alt+Y+D+Z+EVisualize in Excel

Enterprise Performance Reporting Keyboard Shortcuts for Word 2010

Table 18. Enterprise Performance Reporting Keyboard Shortcuts for Word 2010 (assumes Performance Reporting Ribbon is Alt+Y+2)

KeyAction
Author RibbonAuthor Ribbon
Alt+Y+2+Y+3Check Out
Alt+Y+2+Y+4Upload
Alt+Y+2+Y+5Check In
Alt+Y+2+Y+6Submit
Alt+Y+2+Y+7Approve
Alt+Y+2+Y+8Reject
Alt+Y+2+Y+9Refresh
Alt+Y+2+Y+AInspect
Alt+Y+2+Y+BSync
Review RibbonReview Ribbon
Alt+Y+2+Y+3Add New Comment
Alt+Y+2+Y+4Filter Comments
Alt+Y+2+Y+5Hide Anchor, Show Anchor
Alt+Y+2+Y+6Mark Review Complete
Alt+Y+2+Y+7Refresh Comments
Alt+Y+2+Y+8Inspect
Alt+Y+2+Y+9Sync
Sign Off RibbonSign Off Ribbon
Alt+Y+2+Y+3Sign Off
Alt+Y+2+Y+4Reject Sign Off
Alt+Y+2+Y+5Inspect
Alt+Y+2+Y+6Sync

Office 2013 Data Provider Keyboard Equivalents

Subtopics

The tables in this section list ribbon items for Office 2013.

Exceptions are noted in parentheses.

Data Provider Ribbon Keyboard Equivalents for Excel 2013

Table 19. Data Provider Ribbon Keyboard Equivalents for Excel 2013 (assumes provider ribbon is Alt+Y+1)

KeysAction
Alt+Y+1+Y+2Analyze (Planning only)
Alt+Y+1+D+RRefresh
Alt+Y+1+D+R+RRefresh, Refresh
Alt+Y+1+D+R+SRefresh, Refresh All Worksheets
Alt+Y+1+D+DDrill-through
Alt+Y+1+A+MAdd Member
Alt+Y+1+D+BSubmit Data
Alt+Y+1+D+ACell Actions
Alt+Y+1+D+ECell Actions, Comments
Alt+Y+1+D+PCell Actions, Supporting Detail (Planning only)
Alt+Y+1+D+TCell Actions, Attachment (Planning only)
Alt+Y+1+D+HCell Actions, History
Alt+Y+1+D+LLock (Planning only)
Alt+Y+1+D+CCalculate
Alt+Y+1+D+C+BCalculate, Business Rules (Planning only)
Alt+Y+1+D+C+UCalculate, Rules on Form (Planning only)
Alt+Y+D+C+CCalculate, Calculate (HFM and Enterprise only)
Alt+Y+D+C+FCalculate, Force Calculate (HFM and Enterprise only)
Alt+Y+1+D+C+TCalculate, Translate (HFM and Enterprise only)
Alt+Y+1+D+C+RCalculate, Force Translate (HFM and Enterprise only)
Alt+Y+1+Y+CConsolidate (HFM and Enterprise only)
Alt+Y+1+Y+C+NConsolidate, Consolidate (HFM and Enterprise only)
Alt+Y+1+Y+C+SConsolidate, Consolidate All (HFM and Enterprise only)
Alt+Y+1+Y+C+LConsolidate, Consolidate All With Data (HFM and Enterprise only)
Alt+Y+1+Y+C+AConsolidate, Calculate Contribution (HFM and Enterprise only)
Alt+Y+1+Y+C+OConsolidate, Force Calculate Contribution (HFM only)
Alt+Y+1+D+ECell Comments
Alt+Y+1+D+UAdjust
Alt+Y+1+D+U+JAdjust, Adjust
Alt+Y+1+D+U+GAdjust, Grid Spread (Planning only)
Alt+Y+1+D+U+AAdjust, Mass Allocate (Planning only)
Alt+Y+1+D+DDrill-through
Alt+Y+1+IInstructions (Financial Management only)
Alt+Y+1+NEntity Details (Financial Management only)
Alt+Y+1+TCreate Journal (Financial Management only)
Alt+Y+1+D+MMore (Planning only)
Alt+Y+1+D+M+JMore, Job Console (Planning only)
Alt+Y+1+D+M+MMore, Member Formula (Planning only)
Alt+Y+1+D+M+IMore, Instructions (Planning only)
Alt+Y+1+D+M+FMore, Offline (Planning only)
Alt+Y+1+D+M+F+TMore, Offline, Take Offline (Planning only)
Alt+Y+1+D+M+F+YMore, Offline, Sync Back to Server (Planning only)
Alt+Y+1+D+M+F+RMore, Offline, Refresh Offline Definition (Planning only)
Alt+Y+1+SSave Formatting (Planning only)
Alt+Y+1+CClear Formatting (Planning only)
Alt+Y+1+AApply Formatting (Planning only)
Alt+Y+1+A+NApply Formatting, None (Planning only)
Alt+Y+1+A+YApply Formatting, Cell styles (Planning only)
Alt+Y+1+A+CApply Formatting, Custom styles (Planning only)
Alt+Y+1+A+AApply Formatting, Custom and cell styles (Planning only)
Alt+Y+1+Y+3Approvals (Planning only)
Alt+Y+1+Y+4Copy Version (Planning only)

Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2013

Table 20. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2013 (assumes Essbase or ad hoc ribbon is Alt+Y+1)

KeysAction
Alt+Y+1+Y+2Zoom In
Alt+Y+1+Y+2+NZoom In, Next Level
Alt+Y+1+Y+2+AZoom In, All Levels
Alt+Y+1+Y+2+BZoom In, Bottom Level
Alt+Y+1+Y+2+EZoom In, Same Level (Essbase only)
Alt+Y+1+Y+2+LZoom In, Sibling Level (Essbase only)
Alt+Y+1+Y+2+GZoom In, Same Generation (Essbase only)
Alt+Y+1+Y+2+FZoom In, Formulas (Essbase only)
Alt+Y+1+Y+3Zoom Out
Alt+Y+1+Y+4Pivot
Alt+Y+1+Y+4+PPivot, Pivot
Alt+Y+1+Y+4+TPivot, Pivot to POV
Alt+Y+1+Y+5Keep Only
Alt+Y+1+Y+6Remove Only
Alt+Y+1+Y+7Member Selection
Alt+Y+1+Y+8Query
Alt+Y+1+Y+8+QQuery, Query Designer
Alt+Y+1+Y+8+RQuery, Run Report
Alt+Y+1+Y+8+EQuery, Execute MDX (Essbase only)
Alt+Y+1+Y+8+DQuery, Data Filter
Alt+Y+1+A+EMember Information (Essbase only)
Alt+Y+1+Y+9Preserve Format (except Enterprise Ad Hoc)
Alt+Y+1+Y+AChange Alias (Essbase only)
Alt+Y+1+A+DData Perspective (Essbase only)
Alt+Y+1+Y+BSmart Slice (except Enterprise)
Alt+Y+1+Y+CCascade (except Enterprise Ad Hoc)
Alt+Y+1+Y+C+SCascade, Same Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+C+NCascade, New Workbook (except Enterprise Ad Hoc)
Alt+Y+1+Y+C+DCascade, Different Workbooks (except Enterprise Ad Hoc)
Alt+Y+1+D+RRefresh
Alt+Y+1+D+R+RRefresh, Refresh
Alt+Y+1+D+R+ARefresh, Refresh All
Alt+Y+1+Y+DPOV
Alt+Y+1+D+WView Comments
Alt+Y+1+D+CCalculate
Alt+Y+1+D+ZVisualize (Essbase only)
Alt+Y+1+NEntity Details (Financial Management only)
Alt+Y+1+TCreate Journal (Financial Management only)
Alt+Y+1+D+Z+EVisualize, Visualize in Excel (Essbase only)
Alt+Y+1+D+DDrill-through
Alt+Y+1+JLinked Objects (Essbase only)
Alt+Y+1+D+UAdjust
Alt+Y+1+D+S+BSubmit Data
Alt+Y+1+D+S+WSubmit Data Without Refresh
Alt+Y+1+D+S+RSubmit Data Range

Oracle Journals Keyboard Equivalents for Excel 2013

Table 21. Oracle Journals Keyboard Equivalents for Excel 2013 (assumes Oracle Journals ribbon is Alt+J)

KeysAction
Alt+J+AAnalyze
Alt+J+MMember Selection
Alt+J+RRefresh
Alt+J+CScan
Alt+J+OPost
Alt+J+NUnpost
Alt+J+USubmit
Alt+J+IUnsubmit
Alt+J+VApprove
Alt+J+JReject
Alt+J+TStatus
Alt+J+BBalance Type
Alt+J+PType
Alt+J+GGroup
Alt+J+LSecurity Class
Alt+J+EEdit
Alt+J+SSave

Oracle BI EE Ribbon Keyboard Equivalents for Office 2013

Table 22. Oracle BI EE Ribbon Keyboard Equivalents for Office 2013 (assumes Oracle BI EE Ribbon is Alt+Y+1)

KeyAction
Alt+Y+1+Y+3View Designer
Alt+Y+1+Y+4Publish View
Alt+Y+1+Y+5Refresh
Alt+Y+1+Y+6Edit Prompts
Alt+Y+1+Y+7Edit Page Prompts
Alt+Y+1+Y+8Copy
Alt+Y+1+Y+9Paste
Alt+Y+1+Y+ADelete
Alt+Y+1+Y+BMask Data

Enterprise Performance Reporting Keyboard Shortcuts for Excel 2013

Table 23. Enterprise Performance Reporting Keyboard Shortcuts for Excel 2013 (assumes Performance Reporting Ribbon is Alt+Y)

KeyAction
Alt+Y+A+ZZoom In
Alt+Y+A+Z+NZoom In, Next Level
Alt+Y+A+Z+AZoom In, All Levels
Alt+Y+A+Z+BZoom In, Bottom Level
Alt+Y+A+UZoom Out
Alt+Y+A+TPivot
Alt+Y+A+T+PPivot (between rows and columns, or from page dimension cells to grid)
Alt+Y+A+KKeep Only
Alt+Y+A+ORemove Only
Alt+Y+A+IMember Selection
Alt+Y+A+AChange Alias
Alt+Y+D+RRefresh
Alt+Y+D+R+RRefresh, Refresh (current worksheet)
Alt+Y+D+R+SRefresh All Worksheets
Alt+Y+D+OPOV (displays the POV toolbar)
Alt+Y+D+ZVisualize
Alt+Y+D+Z+EVisualize in Excel

Enterprise Performance Reporting Keyboard Shortcuts for Word 2013

Table 24. Enterprise Performance Reporting Keyboard Shortcuts for Word 2013 (assumes Performance Reporting Ribbon is Alt+Y+2)

KeyAction
Author ribbonAuthor ribbon
Alt+Y+2+Y+3Check Out
Alt+Y+2+Y+4Upload
Alt+Y+2+Y+5Check In
Alt+Y+2+Y+6Submit
Alt+Y+2+Y+7Approve
Alt+Y+2+Y+8Reject
Alt+Y+2+Y+9Filter Comments
Alt+Y+2+Y+AHide Anchor, Show Anchor
Alt+Y+2+Y+BRefresh
Alt+Y+2+Y+CInspect
Alt+Y+2+Y+DSync
Review RibbonReview Ribbon
Alt+Y+2+Y+3Add New Filter
Alt+Y+2+Y+4Filter Comments
Alt+Y+2+Y+5Hide Anchor, Show Anchor
Alt+Y+2+Y+6Mark Review Complete
Alt+Y+2+Y+7Refresh Comments
Alt+Y+2+Y+8Inspect
Alt+Y+2+Y+9Sync
Sign Off RibbonSign Off Ribbon
Alt+Y+2+Y+3Sign Off
Alt+Y+2+Y+4Reject Sign Off
Alt+Y+2+Y+5Inspect
Alt+Y+2+Y+6Sync

Smart View Panel Navigation

Table 25 displays the keys for navigating in the Smart View Panel.

Table 25. Smart View Panel Navigation

KeysAction
Alt+S+PLaunch the Smart View Panel (Office 2007 and 2010)
F6Switch between Smart View and Office components
TabScroll through Smart View Panel
Up and down arrow keysScroll through items in tree view
Left and right arrow keys

In toolbars, move through buttons

In tree views, expand or collapse a node

Alt+tabMove from tree view to Action Panel
Alt+down arrowOpen the drop-down menu
Up and down arrow keysScroll through drop-down list
EnterSelect an item in the drop-down menu
EscapeCancel selection

Smart Query Panel Navigation

Table 26. Smart Query Panel Navigation

KeysAction
F6Switch between Smart Query and Office components
Ctl+EnterSet focus from a dimension down to its properties
Ctl+X and Ctl+VMove dimensions between axes (select dimension, Ctl+X to cut dimension, Tab to target dimension, then Ctl+V to paste dimension)

Smart Query Ribbon Keyboard Equivalents

Subtopics

The tables in this section list ribbon items for the Smart Query ribbon.

Exceptions are noted in parentheses.

Smart Query Ribbon Keyboard Equivalents for Office 2007

Table 27. Smart Query Ribbon Keyboard Equivalents for Office 2007

KeyAction
Alt+Y+Y+0+1Analyze
Alt+Y+Y+0+2Designer Panel
Alt+Y+Y+0+3Copy
Alt+Y+Y+0+4Paste
Alt+Y+Y+0+5Save
Alt+Y+Y+0+6Open
Alt+Y+Y+0+7Refresh
Alt+Y+Y+0+8Automatic Refresh
Alt+Y+Y+0+9Change Alias
Alt+Y+1+Y+B, Down arrow key once + EnterChange Alias, None
Alt+Y+1+Y+B, Down arrow key twice + EnterChange Alias, More Alias Tables
Alt+Y+Y+1+0Indentation
Alt+Y+Y+1+1Show Distinct Member Names
Alt+Y+Y+1+2Suppress Rows with No Data

Smart Query Ribbon Keyboard Equivalents for Office 2010

Table 28. Smart Query Ribbon Keyboard Equivalents for Office 2010

KeyAction
Alt+Y+1+Y+3Analyze
Alt+Y+1+Y+4Designer Panel
Alt+Y+1+Y+5Copy
Alt+Y+1+Y+6Paste
Alt+Y+1+Y+7Save
Alt+Y+1+Y+8Open
Alt+Y+1+Y+9Refresh
Alt+Y+1+Y+AAutomatic Refresh
Alt+Y+1+Y+BChange Alias
Alt+Y+1+Y+B, Down arrow key once + EnterChange Alias, None
Alt+Y+1+Y+B, Down arrow key twice + EnterChange Alias, More Alias Tables
Alt+Y+1+Y+CIndentation
Alt+Y+1+Y+DShow Distinct Member Names
Alt+Y+1+Y+ESuppress Rows with No Data

Smart Query Ribbon Keyboard Equivalents for Office 2013

Table 29. Smart Query Ribbon Keyboard Equivalents for Office 2013

KeyAction
Alt+Y+1+Y+2Analyze
Alt+Y+1+Y+3Designer Panel
Alt+Y+1+Y+4Copy
Alt+Y+1+Y+5Paste
Alt+Y+1+Y+6Save
Alt+Y+1+Y+7Open
Alt+Y+1+Y+8Refresh
Alt+Y+1+Y+AAutomatic Refresh
Alt+Y+1+Y+BChange Alias
Alt+Y+1+Y+B, Down arrow key once + EnterChange Alias, None
Alt+Y+1+Y+B, Down arrow key twice + EnterChange Alias, More Alias Tables
Alt+Y+1+Y+CIndentation
Alt+Y+1+Y+DShow Distinct Member Names
Alt+Y+1+Y+ESuppress Rows with No Data

Installing and Configuring Help Locally

After installing Smart View, the online help is retrieved from a URL hosted on the Oracle.com web site. This is the default behavior for Smart View, and no changes are required by users to launch help.

However, you may require that the help be installed locally for Section 508 accessibility purposes. To accommodate this, help must be downloaded from My Oracle Support and placed on a local drive, and the Smart View properties.xml file must be modified.

  To install and configure Smart View help locally:

  1. Obtain the patch zip file for this release from My Oracle Support.

  2. Extract the contents of the patch zip file to a local folder on the computer where Smart View is installed.

    For example, extract the contents locally to:

    C:\Oracle\SmartView\

    Under the smartview_help folder, there are 28 language folders; for example:

    C:\Oracle\SmartView
               \smartview_help
                    \ar
                    \cs
                    \da
                    \de
                    \el
                    \en
                    \es
                    \fi
                    \fr
                    \fr_CA
                    \he
                    \hu
                    \it
                    \ja
                    \ko
                    \nl
                    \no
                    \pl
                    \pt
                    \pt_BR
                    \ro
                    \ru
                    \sk
                    \sv
                    \th
                    \tr
                    \zh_CN
                    \zh_TW

    The following language folders contain translated versions of the Smart View help:

                        \de
                    \es
                    \fr
                    \it
                    \ja
                    \ko
                    \nl
                    \pt_BR
                    \zh_CN
                    \zh_TW

    The remaining language folders contain the English version of the help. When you run Smart View in one of those languages (for example, Swedish) and you click a button for Help, the English help is displayed.

    Additionally, the English folder contains a copy of the help in PDF format, smartview_user.pdf.

  3. Modify the helpurlcontext property in the Smart View properties.xml file:

    1. In your Smart View installation, navigate to the SmartView\cfg folder.

    2. Make a backup copy of the original properties.xml file.

    3. Open properties.xml for editing.

    4. Modify the helpurlcontext property, providing the path to the folder that is parent to the language folders, providing the path to the folder that is parent to the language folders using the following syntax:

      <helpurlcontext>file:///parent_language_folder_path/</helpurlcontext>

      Tip:

      Use forward slashes in the syntax and ensure that you enter a final forward slash (/) after the parent language folder path that you provide.

      Using the example from step 2, after extracting the zip contents to C:\Oracle\SmartView, the smartview_help folder is the parent folder of the language folders. Thus, you would modify the parent_language_folder_path placeholder as follows:

      <helpurlcontext>file:///C:/Oracle/SmartView/smartview_help/</helpurlcontext>

  4. Restart your Microsoft Office applications and access the help from the Smart View ribbon.

  5. Repeat this procedure for each computer that requires Oracle Smart View for Office local help.