Navigation:  Calculation Modules > ENERCALC 3D > Introduction >

Spreadsheet Navigation

Previous pageReturn to chapter overviewNext page

The program uses spreadsheets extensively for data input and output.  It offers multiple ways to navigate within a spreadsheet as specified in the following table.

 

FASTFR~1_img3

 

 

Key

Action

up arrow

Moves active cell up one row

down arrow

Moves active cell down one row

right arrow

Moves active cell right one column

left arrow

Moves active cell left one column

Shift+arrow key

Extends selection in direction of arrow key

Page Up

Moves active cell one page up

Page Down

Moves active cell one page down

Ctrl+Page Up

Moves active cell one page left

Ctrl+Page Down

Moves active cell one page right

Home

Moves active cell to first cell in row

End

Moves active cell to last cell in row that contains data

Ctrl+Home

Moves active cell to first row, first column

Ctrl+End

Moves active cell to last row and column that contain data

Tab

Moves active cell to next cell to the right (or at end of row moves to beginning of next row)

Shift+Tab

Moves active cell to next cell to the left (or at beginning of row moves up to end of row above)

Shift+space

Selects current row

Ctrl+space

Selects current column

Shift+Ctrl+space

Selects entire sheet

Ctrl+X or Shift+Del

Cuts current selection or active cell's data to Clipboard

Ctrl+V or Shift+Ins

Pastes Clipboard contents into active cell

Ctrl+C or Ctrl+Ins

Copies current selection or active cell's data to Clipboard

Enter

Active cell moves down

Esc

If sheet is in edit mode, previous cell value replaces new value and edit mode is turned off

F2

If edit mode is on, cell value is cleared

< <