Dragging formlas when inserting columns

  • Thread starter Thread starter melvin
  • Start date Start date
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.
 
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
 
Back
Top