Excel spreadsheet problems

[jivebunny]

Occasionally when I delete lines in a spreadsheet an empty space is created further down the sheet and any entry which was in the affected line(s) further down is lost. Any ideas why this happens?

Jivebunny

[Old_Geezer]

Not for sure. Deleting cells can make the cells underneath rise up one to replace the deleted ones, which can make all sorts of problems if you are not aware and compensate for it. Make sure you are not using delete when you wanted clear.

As for entries being lost, difficult to know why, unless the values it was calculating with had been deleted, causing the cell somehow to become blank. But usually if data is unavaiiable you get an error message in the cell instead.

[HowardKennitby]

Use of absolute/relative cell references causing trouble ? Too little info for anything better.