If you’re new to touch devices, learning a few gestures will help you take maximum advantage of the touch capabilities.
Moving around in a file
|
To… |
Do this… |
Gestures |
|
Scroll |
Touch the screen and slide your finger up and down, left and right. To quickly scroll through large worksheets, either horizontally or vertically, grab the scroll handle |
|
|
Zoom in |
Stretch two fingers apart. |
|
|
Zoom out |
Pinch two fingers together. |
|
Making a Selection
|
To… |
Do this… |
Gestures |
|
Select a cell |
Tap a cell. |
|
|
Select multiple cells |
Tap, then drag the selection handler. |
|
|
Place the cursor |
Tap in the formula bar. |
|
|
Add or edit cell contents |
Double-tap the cell, or tap in the formula bar. |
|
|
Hide the onscreen keyboard |
Tap the Keyboard key. |
|
|
Open the Edit menu for a cell |
Tap the cell. |
|
|
Select all cells that contain data |
Flick the selection handle down or to the right. |
|
Working with Columns or Rows
|
To… |
Do this… |
Gestures |
|
Select or edit a column or row |
Tap the column or row heading. |
|
|
Move one or more cells, or a column or row |
Tap and hold a selected column or row, or a group of cells. Dotted lines animate when the item is ready to move. Drag and drop the selected data wherever you like. |
|
|
Resize a column or row |
Tap and drag the column or row heading. |
|
|
AutoFit the column width or row height to the contents |
Double-tap the column or row heading. |
|
