G
Guest
I have a problem with the new Excel TR2. I have an extensive file that I
update frequently. Some of the formulas in the cells are quite complex. When
I want to do some new stuff, I usually select a column of cells and the next
column to the right, and then hit ctrl-r to copy right.
In the past with Office 2007, this has worked just as I expected; i.e.
formulas in the cell are automatcially incremented in the news column. E.g.,
if one cell has the formulat "=G1" and I copy right, the new cell one row of
has "=H1".
Now it Excel doesn't do make the change from G column to H column in the new
cell that I ctrl-r on (cut and paste also don't work). Althought it's more
weird than than. Currenlty I have about 50 rows. If I select the last cell
in row 1 and the next empty cell to the right, and then hit crtl-r, in my
current case the old row has "data!GM1" and the new cell does update to
"data!GN1." But IF I drag and select all 50 rows in the last column and the
next empty column and ctrl-r, this new cell has "data!GM1," as does the rest
of the rows.
How do I fix this? Is this a bug or a setting?
Thanks!
update frequently. Some of the formulas in the cells are quite complex. When
I want to do some new stuff, I usually select a column of cells and the next
column to the right, and then hit ctrl-r to copy right.
In the past with Office 2007, this has worked just as I expected; i.e.
formulas in the cell are automatcially incremented in the news column. E.g.,
if one cell has the formulat "=G1" and I copy right, the new cell one row of
has "=H1".
Now it Excel doesn't do make the change from G column to H column in the new
cell that I ctrl-r on (cut and paste also don't work). Althought it's more
weird than than. Currenlty I have about 50 rows. If I select the last cell
in row 1 and the next empty cell to the right, and then hit crtl-r, in my
current case the old row has "data!GM1" and the new cell does update to
"data!GN1." But IF I drag and select all 50 rows in the last column and the
next empty column and ctrl-r, this new cell has "data!GM1," as does the rest
of the rows.
How do I fix this? Is this a bug or a setting?
Thanks!