Brexit. The Truth Is Finally Out.
News3 mins ago
Excel spreadsheet problems
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
Jivebunny
Answers
1 to 2 of 2
Best Answer
No best answer has yet been selected by jivebunny. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
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.
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.
1 to 2 of 2
