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.
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 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.
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.
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.)
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.
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.
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.
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.
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.
Конец ознакомительного фрагмента.
Текст предоставлен ООО «ЛитРес».
Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.
Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.