Table 4-5 Enterprise Performance Reporting Ad Hoc Keyboard Shortcuts for Excel 2007 (assumes Performance Reporting Ad Hoc Ribbon is Alt+Y)
Keys | Action |
---|---|
Alt+Y+A+Z | Zoom In |
Alt+Y+A+Z+N | Zoom In, Next Level |
Alt+Y+A+Z+A | Zoom In, All Levels |
Alt+Y+A+Z+B | Zoom In, Bottom Level |
Alt+Y+A+U | Zoom Out |
Alt+Y+A+T | Pivot |
Alt+Y+A+T+P | Pivot (between rows and columns, or from page dimension cells to grid) |
Alt+Y+A+T+T | Pivot To POV |
Alt+Y+A+K | Keep Only |
Alt+Y+A+O | Remove Only |
Alt+Y+A+I | Member Selection |
Alt+Y+A+A | Change Alias |
Alt+Y+D+R | Refresh |
Alt+Y+D+R+R | Refresh, Refresh |
Alt+Y+D+R+S | Refresh, Refresh All Worksheets |
Alt+Y+D+O | POV (displays the POV toolbar) |
Alt+Y+D+Z | Visualize |
Alt+Y+D+Z+E | Visualize in Excel |