Cell cursor neglect cellinfo.
Joergen
How are you deleting the column? If you do as I often do and hit
control space to highlight the column, alt edit delete, you may
inadvertantly delete additional data if you have any cells in column B
merged with cells in A or C since the control space will select any
columns that are merged with column B.
Where is your data that is deleted before it gets deleted? it seems
like deleting an empty column should not cause any loss of data; and
if end-down arrow takes you all the way to the bottom, the column is
either empty or full, and if it is full of data you would probably
know that.
Ken
On Nov 11, 2:45*pm, "Joergen Bondesen" wrote:
Hi NG
I have an odd problem.
Sometimes I get a spreadsheet with records, e.g. 50000 pcs.
Column 2 seems empty, so I mark cell B1 and use key: End - arrow down.
Normally cell cursor stops at the first cell with info, but sometimes the
cell cursor goes to sheet button, so I think the column is empty and then
delete the column and thereby customerinformations.
Any suggestion to how I can avoid this problem?
--
Best Regards
Joergen Bondesen
|