Planning Ribbon Keyboard Equivalents for Excel 2019

Displays the keyboard equivalents for items on the Planning ribbon for Excel 2019.

Table 7-1 Planning Ribbon Keyboard Equivalents for Excel 2019 (assumes provider ribbon is Alt+Y+2)

Keys Action
Alt+Y+2+Y+1 Analyze
Alt+Y+2+D+R Refresh
Alt+Y+2+D+R+R Refresh, Refresh
Alt+Y+2+D+R+S Refresh, Refresh All Worksheets
Alt+Y+2+D+O Display or Hide POV
Alt+Y+2+D+A Cell Actions
Alt+Y+2+D+A+E Cell Actions, Comments
Alt+Y+2+D+A+P Cell Actions, Supporting Details
Alt+Y+2+D+A+T Cell Actions, Attachment
Alt+Y+2+D+A+H Cell Actions, History
Alt+Y+2+D+L Lock
Alt+Y+2+D+C Calculate
Alt+Y+2+D+C+B Calculate, Business Rules
Alt+Y+2+D+C+U Calculate, Rules on Form
Alt+Y+2+D+U Adjust
Alt+Y+2+D+U+J Adjust, Adjust
Alt+Y+2+D+U+G Adjust, Grid Spread
Alt+Y+2+D+U+A Adjust, Mass Allocate
Alt+Y+2+D+D Drill-through
Alt+Y+2+D+B Submit Data
Alt+Y+2+D+M More
Alt+Y+2+D+M+J More, Job Console
Alt+Y+2+D+M+M More, Member Formula
Alt+Y+2+D+M+I More, Instructions
Alt+Y+2+D+M+F More, Offline (Planning on-premises only)
Alt+Y+2+D+M+F+T More, Offline, Take Offline (Oracle Hyperion Planning on-premises only)
Alt+Y+2+D+M+F+Y More, Offline, Sync Back to Server (Oracle Hyperion Planning on-premises only)
Alt+Y+2+D+M+F+R More, Offline, Refresh Offline Definition (Oracle Hyperion Planning on-premises only)
Alt+Y+2+S Save Formatting
Alt+Y+2+C Clear Formatting
Alt+Y+2+A Apply Formatting
Alt+Y+2+A+N Apply Formatting, None
Alt+Y+2+A+Y Apply Formatting, Cell Styles
Alt+Y+2+A+C Apply Formatting, Custom Styles
Alt+Y+2+A+A Apply Formatting, Custom and Cell Styles
Alt+Y+2+Y+2 Approvals
Alt+Y+2+Y+3 Copy Version