Excel help needed

[seahall]

Hi.

I use Excel quite a lot and I always highlight the sheet like Ken says.

I more importantly put a leading zero field in Col A i.e. 000 to 835 on
every file I make, that means you can sort on numerous cols and
make new sheets if required and also you can always go back to the
original file without losing any data.

Sandy

[webmayo]

The problem you had with the sort is just one of many ways a spreadsheet can destroy your data.
There is a free application called GenScriber that is made specifically for transcribing genealogy records.
It is designed to not do the bad things that spreadsheets do. Give it a try.
http://genscriber.com

Now that I have used genscriber, I would never use a spreadsheet for genealogy data.

[webmayo]

Hi,

Great News!!!

It has worked!!!  Have lost a few hundred names but at least that is a small amount to what I could have lost!! 

Lesson learned to double check that ALL columns are highlighted!!!

Learned something new, as did not know I could 'restore'

Thank You! Thank You! Thank You!!

Cancan 

Can I just say something about the 'restore'. It's not actually a restore. It is a drop back.

When you run 'restore' you actually lose everything you did after the time you go back to.
That includes any emails, images, docs, applications etc. Anything you created after the 'restore' date.

It may have helped you recover most of your spreadsheet, but you may have lost more without knowing it.
Immediately after the restore, back up your spreadsheet and move forward again.

[japeflakes]

Suggestion:
If you saved your work as say "March 11th" and then next time March 12th you would be able to go back to any previous data

File> Save as.....

But you probably knew that already