View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default how do I paste without EXCEL increasing the cell number ?

"cgs" wrote:
How do I cut and paste formulas and resultents with
out EXCEL increasing the cell number ?


Although changing relative references to absolute references
might be the best solution for you, there are times when
you might want to do exactly as you stated, retaining the
relative references for some other purpose, e.g. so that they
are indeed modified appropriately when you subsequently
copy-and-paste.

Since you say __cut__ and paste, not copy, a cell move
might meet your needs. Highlight the cells to "cut", then
move the cursor to the highlight border so that you see a
four-way-arrow cursor, then drag the cells to where you
want them. Excel modifies relative references to cells
within the moved cell block, but other relative references
are unmodified.

In cases where I actually want to __copy__ and paste, I
have resorted to a text copy-and-paste. This is unpleasant
because it must be done one cell at a time. Highlight one
cell and copy the text of the formula in the "fx" field.
Press Esc to deselect the cell, then highlight the new
location, then do paste.