Hello everyone
I have built this spreadsheet using a table from Row 20 on. By selecting cell A21 and pulling on the lower right corner, I am able to add more rows with the formulas intact. I have also created a dynamic print range and the sums in Cells O5, E12 & E13 are dynamic also but, ironically, Cell O5 is dynamic only if it is NOT BOLDED.
So, 2 questions,
1) Why does the BOLDING affect the dynamic summation of O5?
2) I want to protect this sheet and have some cells Unlocked but, I cannot pull down on the lower right corner on A21 anymore. I have unlocked all cells from A20 to the end of the spreadsheet but, it still does not work. Help!
http://www.2shared.com/file/Nt_YCFJ2/CVR-2012_12_11-SEMI-FINAL.html
I have built this spreadsheet using a table from Row 20 on. By selecting cell A21 and pulling on the lower right corner, I am able to add more rows with the formulas intact. I have also created a dynamic print range and the sums in Cells O5, E12 & E13 are dynamic also but, ironically, Cell O5 is dynamic only if it is NOT BOLDED.
So, 2 questions,
1) Why does the BOLDING affect the dynamic summation of O5?
2) I want to protect this sheet and have some cells Unlocked but, I cannot pull down on the lower right corner on A21 anymore. I have unlocked all cells from A20 to the end of the spreadsheet but, it still does not work. Help!
http://www.2shared.com/file/Nt_YCFJ2/CVR-2012_12_11-SEMI-FINAL.html