View Single Post
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Stephanie,

You didn't tell all. Did you mean move, or copy? If the cell in A1 contains
a value (non-formula), you can move it to A4 by cutting/pasting, or more
easily be dragging it by it's border. If the cell contains a formula, and
you want the result of the formula in A4, you can do that by doing Copy,
then in A4 do Paste special - Values. Now delete A1. If neither is the
solution you need, perhaps you can describe what's going in in more detail.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Stephane" wrote in message
...
Hi,

I need to move the content of a cell by x number of columns (i.e. A1 to
A4)
but I cannot have a formula in the destination cell. How can I do that
easily?

thanks,