Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Adding cells, using text as number | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |