excel experts?

Discussion in 'After Hours Lounge (Off Topic)' started by Micah Cohen, Feb 6, 2007.

  1. Micah Cohen

    Micah Cohen Screenwriter

    Joined:
    Jun 8, 2000
    Messages:
    1,153
    Likes Received:
    0
    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. [​IMG]

    MC
     
  2. Scott Dautel

    Scott Dautel Second Unit

    Joined:
    Oct 6, 1998
    Messages:
    471
    Likes Received:
    0
    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. WillG

    WillG Producer

    Joined:
    Jan 30, 2003
    Messages:
    5,614
    Likes Received:
    129


    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)
     
  4. LS1 Sounds

    LS1 Sounds Auditioning

    Joined:
    Nov 19, 2006
    Messages:
    6
    Likes Received:
    0
    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. [​IMG]
     
  5. Micah Cohen

    Micah Cohen Screenwriter

    Joined:
    Jun 8, 2000
    Messages:
    1,153
    Likes Received:
    0
    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
     
  6. LS1 Sounds

    LS1 Sounds Auditioning

    Joined:
    Nov 19, 2006
    Messages:
    6
    Likes Received:
    0
    Not that I'm aware of. Let go of the Ctrl key and hit down arrow again.
     

Share This Page