Cell Format changes when data is cut from cells

J

Jack Keat

I have a formated worksheet that I use to print data to pre-printed
forms. Each column of the worksheet is formated for Font, Alignment etc.
When I cut information from one area of the worksheet to another, the
formatting in the cells that I have "cut from" seems to revert back to
default values. Is there any way to prevent the formatting from going
back to defaults?
 
R

Ragdyer

The simplest answer is you'll have to add an additional step.

Instead of "Cut", use "Copy", then go back and use "ClearContents" on the
original..
 
Top