Move in the Microsoft Query panes by using shortcut keys
From Microsoft Query
Move in the Microsoft Query panes by using shortcut keys
Some of the content in this topic may not be applicable to some languages.
Move in the Table pane
| Press | To |
|---|---|
| TAB | Move between tables |
| UP ARROW or DOWN ARROW | Move to and select field names in a table |
| SHIFT+UP ARROW or SHIFT+DOWN ARROW | Select contiguous fields in a table or to cancel selection |
Move between columns and rows in the Data pane or the Criteria pane
| Press | To |
|---|---|
| F5, type the number of the record in the Record box, and then press ENTER | Move to a specific record (row) in the Data pane |
| TAB, ENTER, or RIGHT ARROW (from a selected cell) |
Move to the next column in the Data pane |
| SHIFT+TAB, SHIFT+ENTER, or LEFT ARROW (from a selected cell) |
Move to the previous column in the current row or the last field in the previous record |
| END | Move to the last column in the current row |
| CTRL+END | Move to the last column in the last row |
| HOME | Move to the first column in the current row |
| CTRL+HOME | Move to the first column in the first row |
| DOWN ARROW | Move to the current column in the next row |
| CTRL+DOWN ARROW | Move to the current column in the last row |
| UP ARROW | Move to the current column in the previous row |
| CTRL+UP ARROW | Move to the current column in the first row |
Move the insertion point within a value in a cell in the Data pane or the Criteria pane
| Press | To |
|---|---|
| F2 | Cancel selection and display the insertion point in a selected cell |
| RIGHT ARROW | Move one character to the right |
| CTRL+RIGHT ARROW | Move one word to the right |
| LEFT ARROW | Move one character to the left |
| CTRL+LEFT ARROW | Move one word to the left |
| END | Move to the end of the current line in single-line or multiple-line values |
| CTRL+END | Move to the end of the value in multiple-line values |
| HOME | Move to the beginning of the current line in single-line or multiple-line values |
| CTRL+HOME | Move to the beginning of the value in multiple-line values |
Move between screens in the Data pane or the Criteria pane
| Press | To |
|---|---|
| PAGE DOWN | Move down one screen in a pane |
| PAGE UP | Move up one screen in a pane |
| CTRL+PAGE DOWN | Move right one screen in a pane |
| CTRL+PAGE UP | Move left one screen in a pane |