View source for Shortcuts to navigate and edit a table

[[Category:Analytica User Guide]]
<breadcrumbs>Analytica User Guide > Arrays and Indexes > {{PAGENAME}}</breadcrumbs>


These mouse operations and keyboard shortcuts let you navigate around a table, select a region, and search for text. They are the same as in Microsoft Excel, wherever this makes sense. ''Control+Page Up ''and ''Control+Page Down ''are exceptions.

The ''current cell ''is highlighted, or the first cell you selected in a highlighted rectangular region. In a region, the ''anchor cell ''is the corner opposite the current cell. If you select only one cell, the Anchor and Current are the same cell.
{| class="wikitable"
!Shortcut  type
!Shortcut
!Explanation
|-
! scope="row" rowspan="5" |'''Mouse operations'''
|''Mouse Click''
|Click in a cell to make it the current cell.
|-
|''Mouse Shift+Click''
|Select the region from the previous anchor to this cell.
|-
|''Mouse drag''
|Select the region from the cell in which you depress the left mouse button to the cell in which you release the button.
|-
|''Mouse wheel''
|Scroll vertically without changing the selection.
|-
|''Control+mouse wheel''
|Scroll horizontally without changing the selection.
|-
! scope="row" rowspan="5" |Shortcuts to edit a table

<code>''These shortcut keys speed up editing a table. ''</code>

<code>''Inserting and deleting rows and columns works only if the index(es) are defined as an explicit list, not if it is computed or a sequence.''</code>
|''down-arrow''
|If you have selected the last row, add a row.
|-
|''left-arrow''
|If you have selected the right column, add a column.
|-
|''Control''+i
|If you have selected a row header, insert a row. 
If you have selected a column header, insert a column.
|-
|''Control''+k
|Delete a selected row or column.
|-
|''Control+''v
|Paste copied cells from the clipboard into the table into the selected region. 
If you copy a region and have selected a single cell, it pastes into the region with the current cell as the top-left, if it fits. 

If you paste a cell or region into a larger region, it repeats the copied material to fill out the destination region.
|-
! scope="row" rowspan="2" |'''Search a table'''
|''Control+f''
|Open the [[Find Dialog]] to search for text in the table. Search from the current cell and select the first matching cell, if any.
|-
|''Control+g''
|Repeat the previous '''Find''', starting in the next cell.
|-
! scope="row" rowspan="6" |'''Arrow keys'''
|''arrow (right, left, up, down)''
|Move one cell in the given direction. 
At the end of row, right arrow wraps to the start of the next row. 

At the end of the last row, it wraps to top-left cell. Similarly, for the other keys.
|-
|''Shift+arrow''
|Move the current cell one cell in the given direction. The Anchor cell stays put, causing the selected region to grow or shrink. It does not w rap.
|-
|''Control+arrow''
|Move to the end of row or column in the given direction.
|-
|''Shift+Control+arrow''
|Move current cell to the end of row or column in the given direction, leaving the Anchor where it is, causing the selected region to grow (or flip).
|-
|''End, arrow''
|Two key sequence. Same as ''Control+arrow.''
|-
|''End, Shift+arrow''
|Two key sequence. Same as ''Shift+Control+arrow''.
|-
! scope="row"  rowspan="4" |'''Home key'''
|''Home''
|Move the anchor to the first column, and sets the current cell to be the anchor (so only one cell is selected). 
If you are in the row headers, moves the anchor and current to the first row.
|-
|''Control+Home''
|Select the top-left cell in the table. (Selects one cell.)
|-
|''Control+End''
|Select the bottom-right cell in the table. (Selects one cell.)
|-
|''Shift+Control+Home''
|Select the region between the anchor and the top-left cell. (Leaves current as top-left.)
|-
! scope="row" rowspan="2" |'''Page key'''
|''Page Up, Page Down''
|Move the current cell up or down by the number of rows visible in the window, and scrolls up or down to show that cell. (Selects one cell.)
|-
|''Control+Page Up, Control+Page Down''
|Move the current cell left or right by the number of columns visible in the window, scrolling horizontally to show the new current cell. 

(This is not the same as Excel, in which ''Control+Page Up'', ''Control+Page Down ''toggle between worksheets. Since we don't have worksheets, these do something else useful.)
|-
! scope="row" rowspan="2" |'''Other keys'''
|''Shift+Page Up, Shift+Page Down''
|Move the current cell by the number of rows or columns that currently display on the screen, and scroll vertically by one page. Anchor stays the same, so that the currently selected region expands or shrinks by one page length.
|-
|''Shift+Control+Page Up, Shift+Control+Page''
|Same as ''Shift+Page Up'', but horizontally rather than vertically.
|}
==See Also==
* [[To make an edit table]]
* [[To edit a table]]


<footer>Choice menus and Checkboxes in an edit table / {{PAGENAME}} / Array functions</footer>