MagIC  |  Help Contents  |  Full Text    

MagIC Help Library

First  |  Previous  |  Next  |  Last    

3.5.5  Navigating a SmartBook

Sort

The data in each table may be sorted in an ascending order using up to three columns as keys. To sort on only one column, select any cell in this column and click on the Sort button. To select two or three columns for sorting, push the control key and click on any cell to select the first, second and third column, and then click on the Sort button. The order in which you selected the sorting columns also determines the order in the sorting keys. Note that this action cannot be undone.

Home Button

With this button you can move to the First Column in the active table without scrolling vertically. You can also use Ctrl Shift Home on your keyboard.

Left and Right Buttons

To move multiple columns use the left and right buttons on the toolbar, or hold down the Ctrl Shift keys while using the Arrow Keys on your keyboard. This will allow you to move from one set of columns that are visible in the active Microsoft Excel© window to the next (or previous) set, showing you at least one or two columns overlap. These actions do not cause any vertical scrolling.

End Button

With this button you can move to the Last Column in the active table without scrolling vertically. You can also use Ctrl Shift End on your keyboard.

Tables Menu

Use this menu to navigate between different Tables in the active MagIC SmartBook file. This pull down menu will be automatically updated every time you switch between different SmartBooks using the SmartBooks toolbar menu (see below).

SmartBooks Menu

You can switch between different MagIC SmartBook files using the SmartBooks toolbar menu. If you activate another file through this menu the Tables menu (see above) will be automatically updated.

Note   We recommend that you use this menu option instead of the Microsoft Excel© Window menu. Note that if you switch between different MagIC SmartBook files using the Window menu, the Tables menu may (in some cases) not be updated automatically.