Micah Cohen
Screenwriter
- Joined
- Jun 8, 2000
- Messages
- 1,161
I figured out that [ALT] + [=] is how you "auto sum" in a cell with a sum hidden in it, instead of having to mouse up to the little "auto sum" task bar button. Now...
How do you JUMP DOWN to the next open cell DOWN a column? ("Enter" moves you down a cell, but the cells come up from below the screen boundary and you Enter, Enter, Enter and inevitably skip over the next blank cell because you don't see it coming from off-screen. How do you JUMP DOWN to the next blank cell?)
Can you change the FORMAT of text in a cell from a menu command, as you can in MSWord, to "Title Caps" or "Upper Case" or "Lower Case"?
Excel is made to make your brain boil, I think. Any help would... help.
MC
How do you JUMP DOWN to the next open cell DOWN a column? ("Enter" moves you down a cell, but the cells come up from below the screen boundary and you Enter, Enter, Enter and inevitably skip over the next blank cell because you don't see it coming from off-screen. How do you JUMP DOWN to the next blank cell?)
Can you change the FORMAT of text in a cell from a menu command, as you can in MSWord, to "Title Caps" or "Upper Case" or "Lower Case"?
Excel is made to make your brain boil, I think. Any help would... help.
MC