| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 - how to insert row with formats and totals of previous
hi guys and girls
please help - i need to add more rows to my spreadsheet to include copy of format like text or currency for each cell and end of row totals etc - when i insert row it adds format but not total or formula at the end of row ? in excel 2000 when u insert row it copies all formats and totals from previous row? -- gazza294 -- gazza294 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 - how to insert row with formats and totals of previous
The option ''Extend data range formats and formulas' in the
in Office Button|Excel Options|Advanced|Editing Options should be checked for the behavior you want. "gazza294" wrote: hi guys and girls please help - i need to add more rows to my spreadsheet to include copy of format like text or currency for each cell and end of row totals etc - when i insert row it adds format but not total or formula at the end of row ? in excel 2000 when u insert row it copies all formats and totals from previous row? -- gazza294 -- gazza294 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 vs previous versions | Excel Discussion (Misc queries) | |||
| Excel 2007: All of my formats disappeared | Excel Worksheet Functions | |||
| carrying previous totals from one worksheet to another. | Excel Worksheet Functions | |||
| Calculating monthly totals for current and previous year | New Users to Excel | |||
| How do I forecast monthly and annual totals from previous year's . | Excel Worksheet Functions | |||
Linear Mode
