Formatting Question

[Kent]

Hello,

Is there a way to prevent when you cut & copy a row in a worksheet
that it does not cut your borders, formulas, etc. and you have to go
back and re-add the lines and formulas?

Thank You very much.

Kent Hansen

 

[Bob Tarburton]

One way:
When you copy use Ctrl+C and double tap the C.
This should bring up your clipboard
Now, before you move, you can simply delete the field you
copied without changing formatting.

Ctrl+V will be disabled when you delete, but what you
copied wil be availble on the clipboard.

Just watch out for whether you want to use absolute
references or not in your formulas.