Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
new row without effecting equations
here's the problem -
woorkbook with 12 worksheets, that contain 12 columns, and 50 rows of data each. there are auto sums running on many of the rows and colums. there is at least one column where the rows sum across all worksheets from start to end. i need to add more rows in the middle of the worksheets but want to accomplish this without having to correct all of the auto sums and especially the sums that calculate the worksheets as a group. currently, when a row is added at 40, the data originally in row 40 moves to 41 but still looks for data in row 40 across all worksheets. if i have to change each cell manually to account for the addition of the new rows it could be a couple hours worth of work. any ticks?!? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
new row without effecting equations
If each sheet is exactly the same format, select the first tab in the
workbook, hold shift and select the last tab in the workbook. then make your changes on the selected sheet and the changes will be made on every tab you selected. If the sheets aren't in order, you can hold down ctrl as you select the sheets. On Jul 15, 1:35*pm, NJK wrote: here's the problem - woorkbook with 12 worksheets, that contain 12 columns, and 50 rows of data each. there are auto sums running on many of the rows and colums. there is at least one column where the rows sum across all worksheets from start to end. i need to add more rows in the middle of the worksheets but want to accomplish this without having to correct all of the auto sums and especially the sums that calculate the worksheets as a group. currently, when a row is added at 40, the data originally in row 40 moves to 41 but still looks for data in row 40 across all worksheets. if i have to change each cell manually to account for the addition of the new rows it could be a couple hours worth of work. any ticks?!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows without effecting formulas | Excel Worksheet Functions | |||
Calculation for Effecting Pattern Color, Bold, Etc. | Excel Discussion (Misc queries) | |||
Profile effecting Excel | Excel Discussion (Misc queries) | |||
How do I change a number in a cell without effecting the formula? | Excel Discussion (Misc queries) | |||
Text to Column effecting automatically | Excel Discussion (Misc queries) |