HFM (Financial Management) Ad Hoc Ribbon Keyboard Equivalents for Excel 2013
Displays the keyboard equivalents for items on the HFM Ad Hoc ribbon for Excel 2013.
Table 5-13 HFM (Financial Management) Ad Hoc Ribbon Keyboard Equivalents for Excel 2013 (assumes HFM Ad Hoc ribbon is Alt+Y+1)
Keys | Action |
---|---|
Alt+Y+1+A+Z | Zoom In |
Alt+Y+1+A+Z+N | Zoom In, Next Level |
Alt+Y+1+A+Z+A | Zoom In, All Levels |
Alt+Y+1+A+Z+B | Zoom In, Bottom Level |
Alt+Y+1+A+U | Zoom Out |
Alt+Y+1+A+T | Pivot |
Alt+Y+1+A+T+P | Pivot, Pivot |
Alt+Y+1+A+T+T | Pivot, Pivot to POV |
Alt+Y+1+A+K | Keep Only |
Alt+Y+1+A+O | Remove Only |
Alt+Y+1+A+I | Member Selection |
Alt+Y+1+A+Q | Query |
Alt+Y+1+A+Q+Q | Query, Query Designer |
Alt+Y+1+A+Q+R | Query, Run Report |
Alt+Y+1+A+Q+D | Query, Data Filter |
Alt+Y+1+A+E | Member Information |
Alt+Y+1+A+S | Smart Slice |
Alt+Y+1+A+C | Cascade |
Alt+Y+1+A+C+S | Cascade, Same Workbook |
Alt+Y+1+A+C+N | Cascade, New Workbook |
Alt+Y+1+A+C+D | Cascade, Different Workbooks |
Alt+Y+1+D+R | Refresh |
Alt+Y+1+D+R+R | Refresh, Refresh |
Alt+Y+1+D+R+A | Refresh, Refresh All Worksheets |
Alt+Y+1+Y+3 | Display or Hide POV |
Alt+Y+1+D+E | Cell Comments |
Alt+Y+1+D+C | Calculate |
Alt+Y+1+D+C+C | Calculate, Calculate |
Alt+Y+1+D+C+F | Calculate, Force Calculate |
Alt+Y+1+D+C+T | Calculate, Translate |
Alt+Y+1+D+C+R | Calculate, Force Translate |
Alt+Y+1+Y+4 | Consolidate |
Alt+Y+1+Y+4+N | Consolidate, Consolidate |
Alt+Y+1+Y+4+S | Consolidate, Consolidate All |
Alt+Y+1+Y+4+L | Consolidate, Consolidate All With Data |
Alt+Y+1+Y+4+A | Consolidate, Calculate Contribution |
Alt+Y+1+Y+4+O | Consolidate, Force Calculate Contribuation |
Alt+Y+1+D+D | Drill-through |
Alt+Y+1+D+U | Adjust |
Alt+Y+1+D+Z | Visualize |
Alt+Y+1+N | Entity Details (assumes Oracle Journals extension is installed) |
Alt+Y+1+T | Create Journal (assumes Oracle Journals extension is installed) |
Alt+Y+1+D+S | Submit Data |
Alt+Y+1+D+S+B | Submit Data, Submit Data |
Alt+Y+1+D+S+W | Submit Data Without Refresh |
Alt+Y+1+D+S+R | Submit Data Range |