| General | Alt+Q Alt+Up Tab Shift+Tab Alt+Down Arrow Alt+Right Arrow F5/Ctrl+F5 Esc |
Open Tell me Open tooltip or validation error Move focus to the next control Move focus to the previous control Open a drop-down or look up See the transactions for calculated value Refresh/reload page Close the current page or drop-down. |
| Navigate and select rows | Home/End Ctrl+Home/End Ctrl+Up/Down Ctrl+A Ctrl+Space Ctrl/Shift+Click Ctrl+Shift+Home/End Shift+Up/Down Shift+Page Up/Down Ctrl+Enter |
Go to first/last field Go to first/last row Navigate without losing selection Select all Toggle row selection Add the row/rows to the selection Extend selection to first/last row Add row above/below to selection Add all visible rows above/below to selection Focus out of the list |
| Copy and paste | Ctrl+C Ctrl+V F8 |
Copy rows Paste rows Copy field above into current row |
| Search, filter, and sort | F3 Shift+F3 Ctrl+Shift+F3 Alt+F3 Shift+Alt+F3 Ctrl+Alt+Shift+F3 |
Toggle search Toggle filter pane; focus on field filters Toggle filter pane; focus on totals filters Filter on selected cell value Add filter on selected field Reset filters |
| Report preview | Up/Down Right/Left Ctrl+Home/End Page Up/Down |
Scroll up and down the page Scroll to the right/left Go to the first/last page Go to the previous/next page |
© 2018 Microsoft. All rights reserved.