Скачать книгу

Ribbon Tab will appear with various editing Panels.

img

      It is worth experimenting with all the Tools on the Ribbon Tab. It is also your choice whether you use the right-click menus or the Contextual Ribbon Tab when adding or modifying data in a Table. Some people prefer to use right-click menus for speed and efficiency, others prefer the Contextual Ribbon Tab.

      You may also modify Tables using Grips. When editing with Grips, the left edge of the Table remains stationary but the right edge can move. The upper left Grip is the Base Point for the Table.

      To use Grips, click on a Table border line. The Grips should appear. Each Grip has a specific duty, shown below. To use a Grip, click on the Grip and it will change to red. Now click and drag it to the desired location.

img

      Top of Column

      There is a Grip located at the top of each column line. These Grips adjust the width of the column to the left of the Grip.

      The column will change but the width of the entire Table remains unchanged.

      If you hold the <Ctrl> key down while moving a column Grip, the entire Table adjusts at the same time.

img

      The AutoFill Grip allows you to fill the cells automatically by increments of 1 by selecting 1 cell and dragging to the next cell.

       Make sure the cell data format is set correctly. (Refer to page 5-17.)

      1. Place data in a cell. (Important: Data format should be “whole number”. Refer to page 5-17.)

      2. Click on the AutoFill Grip.

      3. Drag the cursor down to the desired cells.

      4. The cell data advances by 1 unit.

img

      If you select 2 cells AutoFill will follow the incremental advance between the 2 cells. For example, if the date advances by 1 week rather than 1 day.

      1. Fill two cells with the required dates and then select them both by holding down the <Shift> key and left-clicking each one. (Important: Set data format to “Date”. Refer to page 5-17.)

      2. Select the AutoFill Grip.

      3. Drag the cursor down to the desired cells.

      4. Cell data advances by 1 week.

img

      You can specify how you want the cells formatted.

      1. Left click on the AutoFill Grip.

      2. Right click on the AutoFill Grip.

      3. Select an Option from the List. (Description of each is shown below.)

img

      Fill Series: Fills the subsequent cells with the data from the selected cell and advances at a rate of 1 unit. The format of the selected cell is maintained.

      Fill Series Without Formatting: Same as Fill Series except the formatting is not the same as the selected cell.

      Copy Cells: Duplicates the values and the formatting of the selected cells.

      Copy Cells Without Formatting: Same as Copy Cells except the formatting is not the same as the selected cell.

      Fill Formatting Only: Fills only cell formatting for the selected cells. Cell values are ignored.

      To change the data formatting within a cell.

img

      1. Left click inside the cell.

      2. Right click and select Data Format....

      3. Select from the Data type list.

      A long Table can be broken into 2 or more separate Tables using the Table Breaking Grip.

      1. Click on the Table border line.

      2. Click on the Table Breaking Grip.

      3. Move the cursor up to the cell location for the Table Break and left click.

img

      You will notice that the main and sub headings are not repeated on the second part of the broken Table, you can change this in the Properties dialog box.

      To add the headings on both Tables.

      1. Click on the Table border line. (if it is already selected as above, skip this instruction.)

      2. Right click and select Properties.

      3. Scroll down to Table Breaks then left click on No next to the Repeat top labels field, this will enable the drop-down list.

      4. Select Yes from the list.

img

      5. Both Tables will now have the main and sub headings included.

      6. Press the <Esc> key to deselect the Table. The broken Table should now look similar to the image below.

img

      You can also change the distance between the broken Tables by changing the Spacing in the Properties dialog box. You can choose whether to have them closer together or further apart.

img

      There are also many other changes you can make to the broken Table, a detailed description is shown below:

      Enabled:

      If this option is set to Yes you can break the Table, if it is set to No you cannot break the Table.

      Direction:

      Places the broken Table to the left, right or down from the original Table.

      Repeat top labels:

      You can choose to have the top labels shown on all the broken Tables or just the first part.

      Repeat bottom labels:

      If your Table has bottom labels you can choose to have the bottom labels shown on all the broken Tables or just the first part.

      Manual positions:

      This option allows you to move each segment of the broken Table independently with the Move Grip on each one.

      Manual heights:

      If

Скачать книгу