General |
|
Navigate and select rows |
|
Alt+Q |
Open Tell me what you want to do |
Ctrl+A |
Select all |
Tab |
Move focus to the next control |
Home/End |
Go to first/last field |
Shift+Tab |
Move focus to the previous control |
Ctrl+Home/End |
Go to first/last row |
Alt+Down Arrow |
Open a drop-down or look up |
Ctrl+Up/Down |
Navigate without losing selection |
Alt+Right Arrow |
See the transactions for calculated value |
Ctrl+Space |
Toggle row selection |
Esc |
Close the current page or drop-down. |
Shift+Ctrl+Home/End |
Extend selection to first/last row |
|
|
Ctrl+Enter |
Focus out of the list |
|
|
|
|
Copy and paste |
|
Search, filter, and sort |
|
Ctrl+A |
Select all |
F3 |
Toggle search |
Ctrl+Home/End |
Select the first/last row in the list |
Shift+F3 |
Toggle filter pane; focus on field filters |
Home/End |
Go to first/ last field |
Ctrl+Shift+F3 |
Toggle totals filters: focus on totals filters |
Ctrl/Shift+Click |
Add the row(s) to the selection |
Alt+F3 |
Filter on selected cell value |
Ctrl+Up/Down |
Move focus to row above/below |
Shift+Alt+F3 |
Add filter on selected field |
Ctrl+Space |
Extend the selection to include focused row |
Ctrl+Alt+Shift+F3 |
Reset filters |
Shift+Up/Down |
Add row above/below to selection |
Report preview |
|
Shift+Page Up/Down |
Add all visible rows above/below current selection |
Up/Down |
Scroll up and down the page |
Ctrl+C |
Copy rows |
Right/Left |
Scroll to the right/left |
Ctrl+V |
Paste the rows |
Ctrl+0 (zero) |
Fit page in window |
F8 |
Copy field above into current row |
Ctrl+Home/End |
Go to the first/last page |
|
|
Page Up/Down |
Go to the previous/next page |