Friday, November 6, 2015

Edit Table

Select A5 cell


Rows panel > Insert Below


Cross-select A6 & B6
Merge panel > Merge By Row


Select C6 cell
Insert panel > Formula - Sum


Cross-select C3 to C5
Press Enter to confirm the formula

Click the square grip and drag to right


The sum fit in the cell


Data Format - Custom Table Cell Format ...


Click Additional Format


Conversion factor: 1/10000


Precision: 0
Preview: 105


mm convert to m


Cross-select A3 to A5

Cell Styles panel > Justification - Middle Left


The names align to middle left


Cross-select A1 to C6
Cell Styles panel > Edit Borders


Lineweight: 0.7 mm
Color: Blue
Pick the Outside Border icon


Color of outside border become blue


Select the title cell
Background color - Cyan


Click 2 to select the row 2 header
Background Color: Yellow

Press Esc to deselect the cells
Click the outline of the table
Click the down arrow and drag up to adjust the row height


Press Esc to deselect it

No comments:

Post a Comment