Problems when deleting

[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

 

[mpb1]

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

 

[Matt G]

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

 

[Dave Peterson]

Is there any chance that you deleted a range (not the entirerow) and said shift
up or shift left?