Saving files in Micr. Office

  • Thread starter K_Speed
  • 4 comments
  • 448 views
K

K_Speed

262
So, I am a IT-Salesman apprentice at a Middle Sized company. We have around 300 employees here at this part of the world

We own around 70 - 80 Laptops for salesmen and architects.

I happened to make a list into Excel of all the Laptops including the owners, type of laptop (all from DELL), date of delivery etc.

So today I added 2 new ppl to the list. As always I sort by name, great feature. You know which feature I mean?

Now.

What happens is I highlight the "Owner" fields and say "Sort". This time I click "Continue with these fields" (dunno if its exactly that way).
Anyways that ****ing function sort the list but not in connection with the the other fields. This means that everything that was next to the owners list stayed where it is and only the owners fields moved to its position = the owners are totally misplaced. I didnt realize that then.

So what do I stupid do? Hit SAVE. Which is a great function too. I close the file, being in hurry, and come back to it later and see that eveyrthing is in wrong order.

Now of course after youve saved it u cant move a step back. I hate it!

I mean if you save something that means you want to continue from there again later on no? But it doesnt mean that its completely done so you should be able to move back steps.

I know this is a small problem compared to other things, but these little ****ing things piss me off.

**** man, and my boss asked 2 days before if I was still updating that list, and hell I was. And its all messed.

I know mistakes happen, but I hate it when I make them!
 
Too late to help now, but in the future, highlight ALL the fields.

This was a tough lesson, but one that most of us will learn sooner or later. :)

You may want to consider MS Access as an alternative to 'lists' instead of using Excel. It will function more the way that you would expect it to as it retains all fields to that record, regardless of how you sort it.

:cheers:
 
Pako
Too late to help now, but in the future, highlight ALL the fields.

This was a tough lesson, but one that most of us will learn sooner or later. :)

You may want to consider MS Access as an alternative to 'lists' instead of using Excel. It will function more the way that you would expect it to as it retains all fields to that record, regardless of how you sort it.

:cheers:
Click to expand...

Thx for the reply
Yea, I knew about highlighting all fields and then sorting things. I was in a hurry and just wanted to sort it before I go.

I highlight the field I want to sort and then its automatically on "Mark all fields" something like that, but this time I hit keep this field and sort it. So I did that and then a colleague asked me something, then I hit save put my jacked on and ran off.

When I got back it was too late to change anything.

Maybe I should take that access into perspective, never used it.

Yea yea saving...from heaven to hell in a click.

Maybe one of those small things Billy Boy should look forward to fixing (makin better I guess) to.
 
Been in a similar situation myself once before. Only once though. After that i made sure that i made a copy of any files i was working on before i touched the contents. That way whenever you make a mistake, and they do happen, you will have something to fall back on.

Still as Pako said, it's too late for this time, but hopefully you know what to do next time :)
 

Latest Posts

Back