Problems when deleting

  • Thread starter Thread starter Matt G
  • Start date Start date
M

Matt G

Ok...

Has anyone ever experienced issues when deleting
rows/columns of other data being scrambled, so to speak?
It seems that when a column/row is deleted that other data
gets out of its proper row/column and into other spots.
Can anyone provide any insight into this problem?

Thanks,
Matt G
 
Hi Matt
This is because some of your associated formulae have absolute referencing
and others relative referencing to the deleted cells.
Just amend formulae as required.
Mathew
 
Mathew,

I'm not sure I understand. The way our spreadsheet is
setup there are no fromulae in it. We're using it simply
as a method of putting names, addresses, and phone numbers
into a spreadsheet. Would this still have something to do
w/absolute referencing? If so, how can I change this?

Tks a lot,
Matt
 
Is there any chance that you deleted a range (not the entirerow) and said shift
up or shift left?
 
Back
Top