To create an outlined spreadsheet you do the following.
1) In cell A1, write GROUP 1
2) Select rows 2 to 9
3) From the main menu, select Data | Groups | Group
4) In cell A10, write GROUP 2
5) Select rows 11 to 19
6) From the main menu, select Data | Groups | Group
To format the cells do the following
1) In cell B1, type TOTAL 1
2) Format the cell as =SUM(A2:A9)
3) In cell B10, TOTAL 2
4) Format the cell as =SUM(A11:A19)
If I now need to add cells to my TOTAL 1, I then need
to change the format of cell B1. Can this be done
automatically somehow?
Bookmarks