MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Inserting a CELL into a worksheet


Posted by Kathleen Auger on October 07, 2000 7:33 AM

I'm currently taking an online course through our local junior college in which we are learning all modules of Office 2000. I'm arguing with my teacher over a question on one of our Excel quizzes. I feel that the answer she claims to be correct is incorrect as it is not worded properly. The quiz question is "Inserting a CELL into a worksheet causes...:" She says the correct answer is:..."other cells in that ROW to shift either down one row or other cells in that COLUMN to shift over one column to the right." I contend that this is not correct. The correct answer should be that it causes "other cells in that COLUMN to shift either down one row (as the whole row does not shift), or other cells in that ROW to shift over one column to the right (as the whole column does not shift). I need feedback on this to support my claim. Or if I'm wrong, I'll eat my words. Thanks!


Posted by Ivan Moala on October 07, 2000 3:28 PM

For what it's worth I would have to agree with you.


Ivan

Posted by Celia on October 07, 2000 5:30 PM

Or more accurately :-
"either causes cells in that COLUMN beneath the inserted cell to shift down one row, or causes cells in that ROW to the right of the inserted cell to shift over one column to the right."
Celia