Jump to content



Sign up for a free account to remove the pop-up ads

Signing up for an account is fast and free. As a member you can join in the conversation, enter contests and remove the pop-up ads that guests get. Click here to create your free account.

Photo
- - - - -

excel experts?


This topic has been archived. This means that you cannot reply to this topic.
5 replies to this topic

#1 of 6 OFFLINE   Micah Cohen

Micah Cohen

    Screenwriter



  • 1,156 posts
  • Join Date: Jun 08 2000

Posted February 06 2007 - 03:15 AM

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. Posted Image

MC
ultramicah@yahoo.com

"There's nothing funny about a clown in the moonlight." - Lon Chaney

#2 of 6 OFFLINE   Scott Dautel

Scott Dautel

    Second Unit



  • 471 posts
  • Join Date: Oct 06 1998

Posted February 06 2007 - 03:44 AM

To jump down to the next empty cell use ... (End)(down arrow). If you are in an empty cell this jumps to the next full cell. Also works with (up arrow), etc. As far as formatting text ... ctrl_U = underline, ctlr_B = bold, ctrl_I = italics. This is sames as MS Word. I dont believe there is a shortcut to change font case, but there are commands =UPPER() or =LOWER(), which convert he target cells

#3 of 6 OFFLINE   WillG

WillG

    Producer



  • 5,235 posts
  • Join Date: Jan 30 2003

Posted February 06 2007 - 03:47 AM

I'm not sure that you can do it right from a menu command but you can use a formulas to do those things. For Title Caps do =PROPER(cell number) for upper case do =UPPER(cell number) for Lower case do =LOWER(cell number)
STOP HIM! He's supposed to die!

#4 of 6 OFFLINE   LS1 Sounds

LS1 Sounds

    Auditioning



  • 6 posts
  • Join Date: Nov 19 2006

Posted February 06 2007 - 04:48 AM

Use Ctrl + Arrow keys to jump to the next open cell. Also works with Shift to select the range of cells.

Ctrl + 1 is the keyboard shortcut for Format Cells.

Also did you know that holding down Ctrl while scrolling with the mouse wheel zooms in and out? I use that one a lot. Posted Image

#5 of 6 OFFLINE   Micah Cohen

Micah Cohen

    Screenwriter



  • 1,156 posts
  • Join Date: Jun 08 2000

Posted February 06 2007 - 05:07 AM

CTRL + [the down arrow] DOES NOT jump down to the next empty cell down the column. In fact, it merely jumps to the cell ABOVE the next empty cell. How do I get INTO THE EMPTY CELL without Enter, Enter, Enter, whoops! missed it, back arrow? Can I? MC
ultramicah@yahoo.com

"There's nothing funny about a clown in the moonlight." - Lon Chaney

#6 of 6 OFFLINE   LS1 Sounds

LS1 Sounds

    Auditioning



  • 6 posts
  • Join Date: Nov 19 2006

Posted February 06 2007 - 05:48 AM

Not that I'm aware of. Let go of the Ctrl key and hit down arrow again.