Skip to main content

Keyboard and mouse

Scrolling​

The table scrolls inside the visual with the mouse wheel and by touch (with momentum). When the focus is on the table, these keys scroll it:

KeyScrolls
Arrow Down / Arrow UpA line down / up
Arrow Right / Arrow LeftA step right / left
Page Down / Page UpA page down / up
Home / EndTo the top / bottom

The keys are left alone while you type in a field, and while a menu, a side panel or a dialog is open (they have their own use of the arrow keys).

Copy​

KeyCopies
Ctrl+C (Cmd+C on a Mac) with cells selectedThe cells as text, laid out as in a spreadsheet: one line per row (in table order), a tab between columns (in column order). A place between selected cells that is not selected stays empty. Cells that have scrolled out of the window are formatted from their value. The selection outline flashes briefly.
Ctrl+C with the first column selectedThe row labels with the corner cells above them - or, narrowed to the header, the corner cells alone - as text and HTML.

While you edit text (the Font Name box, a rename field), Ctrl+C is that field's own copy. For whole columns, rows or the table, use the right-click menus or the Export tab.

Selecting​

KeyWith a click
Ctrl / CmdAdds one item to the selection, or removes it
ShiftSelects a range from the last item you clicked

Details are in Selecting.

Editing fields​

FieldKeys
Rename Column, Row Header name, Set Width inputEnter accepts, Esc cancels. In Rename Column with several columns selected, Enter and Tab go on to the next header.
Ribbon boxes (Font Name, Font Size, Number Format)Enter or leaving the box applies
Dialogs (Number Format, Financial Headers Settings, the Reset confirmation)Enter confirms, Esc cancels
Menus and the small rule formsEsc closes
A card in the Formatting panelEnter or Space opens it

Mouse​

ActionResult
Drag the right edge of a headerResizes the column (Set Width)
Drag a rule's ⋮⋮ handle in the Conditional Formatting panelChanges its priority
Click a Layer ToggleOpens the table down to that layer
Click the + / - iconOpens or closes a row or a group of columns
Right-click a row label / column headerThe row / column menu
Right-click a value cellPower BI's own menu