Outperform Actions Cheat Sheet

How to…	Action
Change a cell value (modify)	Double click, then type
Change a cell value (paste)	Edit Menu; or Ctrl-V.  Paste accepts internal clips & external tab-separated text. The rectangular clip is pasted such that its top-left coincides with focused cell, as in MS Excel. The clip overrides editable cells and skips non-editable cells without further (possibly annoying) notifications. Pasting to sums is possible. When pasting a rectangular clip to an area that contains sums as well as some of its parts, it will process the pasted values in lexical order.
Change a cell value (replace)	Start typing (no click needed)
Change a cell value (revert)	Select cell(s), then choose Revert from menu (Ctrl-Shift-R)
Change many values	Copy many values, then paste; or use the "Extend Value to Selection" menu (Ctrl-Shift-V)
Chart (show inline)	Increase the height of the row by dragging the row separator in the margin on the left (Ctrl-Shift-C)
Chart (hide inline)	Double click row separator (Ctrl-Shift-C)
Columns (arrange for printing)	Select horizon columns & drag separator to make them the same size
Columns (show hide)	Right-click in column headers
Columns (sort)	Right-click in column headers
Columns (view horizon)	Scroll horizontally, use freeze columns
Find a value (in sheet)	Find from Edit menu; or Ctrl-F
Find a value again	Find Next from Edit menu; or Ctrl-G
Find changes	Find Next Change from Sheet menu; or Ctrl-Tab
Find value (in DB)	Double click on the value; or type in search tool strip
Navigate all cells	Use mouse; or Arrow, Home, End Page Up/Down keys
Navigate changes	Use Ctrl Tab/Enter keys (with Shift to move backwards)
Navigate editable cells	Use Tab/Enter keys (with Shift to move backwards)
See complete cell value	Positing mouse over cell (tool tip will pop up); or Widen column by dragging column separator in header; or Auto-size column to fit by double click in separator
See original cell value	Position mouse over changed cell (tool tip will pop up)
Select	Click & drag; or use arrow, home, end, page up/down keys
Select (extend)	As above, with Shift key pressed
Select (for editing)	Use Tab or Enter keys
Zoom 100%	Sheet Menu; or Ctrl-Shift P
Zoom in/out	Sheet Menu; or Ctrl-Shift I/O; or Ctrl +/- ; or Ctrl-mouse-wheel
Zoom to Fit	Sheet Menu; or Ctrl-Shift F

Keyboard actions

Key	Action	Comment
Arrow down	Go one cell down	(no wrap)
Arrow left	Go one cell left	(no wrap)
Arrow right	Go one cell right	(no wrap)
Arrow up	Go one cell up	(no wrap)
Backspace	Clear cell and start editing
Delete	Delete	Sets all editable values in the selection to NULL
End	Go to last cell in row
Enter	Go to next editable cell	Chinese lexical order, wrap-around; limit wrap to selection if there is one, as in MS Excel - Exception: when you are in a button, the Enter key behaves like clicking the button.
Escape	Exit editing mode without change
Home	Go to first cell in  row
Page Down	Scroll one visible page down
Page Up	Scroll one visible page up
Tab	Go to next editable cell	Lexical order, wrap-around; limit wrap to selection if there is one, as in MS Excel.
0 (Zero)	In a "check box" cell: check off
1 (One)	In a "check box" cell: check on
Any other key	Start editing

Keyboard actions (with Ctrl and Shift)

Modifier-Key	Action	Comment
Ctrl-- (Minus)	Zoom out	As usual in browsers
Ctrl-+ (Plus)	Zoom in	As usual in browsers
Ctrl-0 (Zero)	Zoom 100%	As usual in browsers
Ctrl-A	Select All
Ctrl-C	Copy	Copy selection rectangle; In addition to DP, external programs that accept tab-separated text (Excel, Word, Text editors etc.) can paste that clip
Ctrl-End	Go to last cell in sheet
Ctrl-Enter	After updating cell content stay in the same cell
Ctrl-F	Find matching value	(wraps)
Ctrl-G	Find next matching value	(wraps)
Ctrl-Home	Go to first cell in sheet
Ctrl-Tab	Go to next change
Ctrl-V	Paste	See above How To…
Ctrl-X	Cut	Same as Copy followed by Delete
Ctrl-Shift-End	Extend selection to end of sheet
Ctrl-Shift-C	Show/Hide inline chart
Ctrl-Shift-F	Zoom to Fit (toggle)	This is sticky: the sheet is will be resized to fit continuously to the environment, until you turn it off directly or indirectly by choosing other zoom action.
Ctrl-Shift-Home	Extend selection to start of sheet
Ctrl-Shift-I	Zoom in
Ctrl-Shift-O	Zoom out
Ctrl-Shift-P	Zoom 100%
Ctrl-Shift-R	Revert changes in selection
Ctrl-Shift-Tab	Go to previous change
Ctrl-Shift-V	Copy Focus Value to all other editable cells in the selection
Shift-Arrow down	Extend selection one cell down	(no wrap)
Shift-Arrow left	Extend selection one cell left	(no wrap)
Shift-Arrow right	Extend selection one cell right	(no wrap)
Shift-Arrow up	Extend selection one cell up	(no wrap)
Shift-End	Extend selection to end of row
Shift-Enter	Go to previous editable cell	Reverse Chinese lexical order, wrap-around; limit wrap to selection if there is one, as in MS Excel
Shift-Home	Extend selection to start of row
Shift-Tab	Go to previous editable cell	Reverse lexical order, wrap-around; limit wrap to selection if there is one, as in MS Excel

Mouse actions

In Cells	Action	Comment
Down	Focus
Shift-Down	Extend selection
Down & Move	Focus & Select	Except when in button, in which case it will track button
Down & Move off-window	Extend Selection & auto-scroll
Down & Move across freeze boundary	Auto scroll
Move over	Show cell tooltip	The tooltip shows the whole value when it doesn't fit in the cell and/or the original value when the cell value has been changed
Click	In button: do button action	The button actions are application, model and report specific
Double click	In editable cell: start editing mode
Double click	In searchable cell: set search filter	This used to be a single-click in the data grid
Right Click	Show sheet context menu	Depending on the current cell

In Column Headers	Action	Comment
Down	Select whole column
Shift-Down	Extend selection by whole columns
Down & Move	Focus & Select whole columns
Down & Drag Separator	Change column width	If the column to be sized is part of the selection of multiple columns, this is a multi-resize, as in MS Excel, but with real-time feedback
Double Click Separator	Auto-Size column to fit content width	When you have multiple columns selected and you click in one of their separators, it will auto-size all those columns
Right Click	Show column context menu	Depending on the current column header

In Row Margins	Action	Comment
Down	Select whole row
Shift-Down	Extend selection by whole rows
Down & Move	Focus & Select whole rows
Down & Drag Separator	Change row height	With a freeze column and numeric data, an inline chart will be shown as well.
Double Click Separator	Revert to standard row height
Right Click	Show sheet context menu	Depending on the current row

Scroll wheel	Action	Comment
Turn forward	Scroll Up
Turn backward	Scroll Down
Ctrl-Turn forward	Zoom In
Ctrl-Turn backward	Zoom Out