Tuesday, November 17, 2009

I am so frustrated right now!!!!

I recently upgraded to Microsoft Office 2007 and I hate it!!! I hate it because you have to re-learn things you already know or they change some features/functionality!

For example, "Freezing Panes" in Excel. Before I could select the cell where I wanted the panes to be frozen, so that as I am scrolling through the spreadsheet the headers (labels) at the top and the columns to the left don't move. This feature is very helpful because it keeps you from scrolling back to see what information your looking at.

I'm in Personnel, so my data is people; names, employee numbers, titles, etc. In this particular spreadsheet, I need to freeze the 1st 4 columns on the left HOWEVER, in the newever version of Excel it only freezes the first column. My first column is the employee number, I can't identify who I'm looking at by the number, so my option would be to move my columns so that the last name is the first column. Well, this doesn't help. Why? We have employees with the same last name. So, I'm back to square one trying to figure out which employee I'm looking at. So, when you're working with a large spreadsheet this can be frustrating---scrolling back and forth. I don't know how many times I've scrolled back only to forget the data I was looking at originally. So, I scroll back, try to remember the number in my head, and scroll back to the front section--UGH!!!

So, let me stop complaining and start looking through Microsoft's website to determine if there is a solution to this. I'm sure there is, but this is a part of my frustration....why change these features that have been common with all versions of Excel, only to have to go hunt for the solution. I just need to calm down long enough to find the fix, but then I start thinking about the other features that are no longer a simple task, but a long drawn out process of many steps.

Wish me luck!

3 comments:

  1. I know what you mean. I upgraded my computer at home to Windows 7 a few months ago. At first I hated it! I hated the fact I had to re-learn everything. But now that I'm getting use to it I actually like it better. I hope over time you get use to it and end up liking it. Good Luck!

    ReplyDelete
  2. Wow, I am sorry. I didn't like Window's Vista at all. But now I am a Mac person, I am still a little PC though, so if you ever wanted to try something new I would check out Macs. Also, there probably are some training books you can pick up for Windows 7. Not sure why Microsoft keeps changing and complicating stuff. I think it's because the people that create the software are techy and expect everyone else to be to. Then it could be a money thing. Sad, reality. But try Mac's, they're good!

    ReplyDelete
  3. In my little nonprofit world, so many other nonprofits haven't updated their systems so I have that I have to save all my docs in Word 97/03 format. No one can ever open my attachments!

    ReplyDelete