Things that bother me about excel, and other pet peeves

[steve case]

<ul><tt>Why not have an Excel Light and an Excel Pro version?
</tt>[/list]


There should be a "Lite" version of a lot of software. Especially the remotes for DVD players.
.
.
.
.
.

 

[xld]

Shame you didn#'t check all that first, your intervention effectively destroyed a valid point from Felix.

 

[Joe4]

Shame you didn#'t check all that first, your intervention effectively destroyed a valid point from Felix.

I disagree. Microsoft Works is a "lite" or dummied down version of Excel.

Also, this is a discussion thread. I do not believe I "destroyed" anyone's point. I was merely contributing to the discussion, just like Felix was.

 

[steve case]

How about those toggle keys that can really screw you up until you figure out what's wrong. They are:

Caps Lock - This has to be the number one offender, how many times during the day is it set wrong and you have to go back and re-type a sentence or two because you accidently pressed it?

Num Lock - Right up there with Caps Lock. Type in a few numbers and all of a sudden you’re at line 65536 and you don't know how you got there.

Insert - Very annoying when you look up at the screen to find out you've just typed over some very important information. And there is no little green light to tell you it’s turned on.

Scroll Lock - Doesn't happen very often, but very annoying when it does. What’s it for anyway?

My solution? I'd like a keyboard where all four of those little buggers were up in the corner out of the way where they couldn't be toggled by accident. Like how about where those little green lights are?

If such a keyboard is on the market I'd like to have one.

 

[just_jon]

My problem isn't with the software, alas, but the operator.

He's gone and gotten old!

 

[Oorang]

StACase: I think your idea has some momentum behind it already http://capsoff.blogspot.com/

 

[MrByte]

In our company it is still the 2000 version. 99 out of 100 users don't need the bells and whistles of Excel and use it mostly instead of the Windows calculator anyway... even copy - 'paste special values' is something most of our users have never ever heard of...

Why not have an Excel Light and an Excel Pro version?

Don't give MS another idea to make $$ from us. That would be my petpeev in this forum, WG has too much $$.

 

[steve case]

Follow this link:

http://www.mrexcel.com/board2/viewtopic.php?t=259418

I've noticed this one too. I download data, several hundred lines worth, a large portion of which I delete, and the scroll bar continues to take me to the last row where data used to be.

Doesn't matter if I hit the delete button or use Edit and delete the rows.

 

[Richard Schollar]

Follow this link:

http://www.mrexcel.com/board2/viewtopic.php?t=259418

I've noticed this one too. I download data, several hundred lines worth, a large portion of which I delete, and the scroll bar continues to take me to the last row where data used to be.

Doesn't matter if I hit the delete button or use Edit and delete the rows.

Use Edit>Clear>All instead

 

[SydneyGeek]

Once you delete the rows, save the file. That resets the Used Range. You can check by hitting Ctrl + End.

Denis