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