User Guide

To change 3-D spreadsheet range syntax
1 Click Tools } Settings.
2 Click Compatibility.
3 In the 3-D syntax area, click one of the following options:

A..B:A1..B2 — expresses spreadsheet references first, followed by a colon and the cell
coordinates. This syntax makes group references more concise.

A:A1..B:B2 — refers to each corner of the 3-D selection with the spreadsheet reference
included
When you click a new cell, all existing 3-D references in formulas in open notebooks
switch to the new syntax.
To select cells from a dialog box
1 Click the Range picker .
2 Select the cells you want to appear in the edit field of the dialog box.
3 Maximize the dialog box.
You can also select cells by double-clicking the contents of the edit field.
To quickly select data on a spreadsheet
1 Select one cell within a block of cells.
2 Right-click a toolbar, and click Data manipulation.
3 On the Data manipulation toolbar, click Select table .
All the cells are selected.
To quickly move to a corner of a block of cells
1 Select one cell within a block of cells.
2 Right-click a toolbar, and click Data manipulation.
3 Click one of the following navigation tools:

Top left of table button

Top right of table button

Bottom left of table button

Bottom right of table button
To select a row or column

Select the row or column heading.
To select multiple spreadsheets
1 Click the tab of the first spreadsheet to select.
2 Hold down SHIFT while you click the last spreadsheet tab you want included in the selection.
A black line appears under the tabs.
166 Quattro Pro 10