Dragging formlas when inserting columns

M

melvin

Hi folks,

When I insert a column within a large data field, all formats of the
cells to the right are included in the new column's cells. I am
looking to include not only the formats of the cells to the left but
also the formulas of the cells to left as well (as if being dragged
from left to right).

Does anyone know if this can be done?

Also, how do you prevent formulas from being 'knocked out' of place
when adding columns of information??

Any help in this area is greatly appreciated

Kindest regards,

Stuart.
 
F

Frank Kabel

Hi
for your first question this can't be done automatically (or only with
great effort - IMHO). So I would simply copy the adjacent column and
insert it with 'paste Special' as formulas
 
Top