Forum Discussion
cutting and pasting informatio in cells without affecting the formulas that refer to those cells
I have list of names and each name has a number associated with it. This is two columns: A: Name (text) B: Hours (number) Then I have formulas in columns C and D that refer to A and B and also...
jsifly Transforming the table to a structured Excel table (Ctrl-T) and using structured references could help. I note you had the sheet protected. If you want to keep that you can drag A6:B7 to down one row. But you can't insert a row. You'll see that the formula on row 6 will return zero until you put something in B6 and the formulae on rows 7 and 8 have followed one row down.