P
paul.domaskis
In Excel 2003, I can insert a row into a list by inserting a row into
the spreadsheet. That is, I can right-click along the row numbers
along the left, then insert a row.
However, if I try to insert a copied a spreadsheet row, I get the
message that I am trying to shift cells down within the list. That
is, I select a row by clicking the row number on the left, press ctrl-
C, then right-click another row on its row number at the left, and
choose insert copied row (or maybe insert pasted row -- I'm don't have
access to Excel at the moment to verify).
Inserting a copied/pasted row does the same thing to the list as
simply inserting a row, in the sense that it shifts all list rows
down. Is there a particular reason why Excel would disallow one and
not the other? Or is this functionality simply something that Excel
has yet to catch up on? Is it the same in Excel 2007 (not that I can
get it, but just curious).
the spreadsheet. That is, I can right-click along the row numbers
along the left, then insert a row.
However, if I try to insert a copied a spreadsheet row, I get the
message that I am trying to shift cells down within the list. That
is, I select a row by clicking the row number on the left, press ctrl-
C, then right-click another row on its row number at the left, and
choose insert copied row (or maybe insert pasted row -- I'm don't have
access to Excel at the moment to verify).
Inserting a copied/pasted row does the same thing to the list as
simply inserting a row, in the sense that it shifts all list rows
down. Is there a particular reason why Excel would disallow one and
not the other? Or is this functionality simply something that Excel
has yet to catch up on? Is it the same in Excel 2007 (not that I can
get it, but just curious).