"End" key function needed

Discussion in 'macOS' started by GGJstudios, Dec 2, 2009.

  1. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #1
    OK, you know I've searched for this before posting! :)
    I know that on a Mac keyboard with no "End" key, that +right arrow moves to the end of a line/row and +left arrow moves to the beginning of the line/row. What I need is something different.

    Using Excel in Windows, if I have a column that has blank cells and occasionally has a cell with data in it, (or the reverse: cells that have data and occasionally an empty cell), I can press and release the End key, then press the down or up arrow to move to the next cell in the column that is or isn't empty.

    However, there is no End key on my Mac, so how can I achieve the same functionality? Any ideas?
     
  2. xUKHCx Administrator emeritus

    xUKHCx

    Joined:
    Jan 15, 2006
    Location:
    The Kop
    #2
    Holding command and then using the arrow keys seems to achieve pretty similar results in Excel 2004 on my mac.
     
  3. GGJstudios thread starter macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #3
    Using Excel 2008:
    +down arrow moves down one cell
    Option+down arrow moves to another space in Spaces
    Control+down arrow moves to the bottom of the worksheet
    fn+down arrow moves down one page

    Nothing will move to the next empty/not empty cell. Again, in Windows, you achieve this by pressing and releasing the End key, before using an arrow key. On a Mac, I can't find an equivalent function.
     
  4. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #4
  5. GGJstudios thread starter macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #5
    Yes, I know how to create keyboard shortcuts and have already created several. However, that doesn't help when there is no menu item for the End key. You can't create a keyboard shortcut without a menu command.
     
  6. gloubibou macrumors member

    Joined:
    Jun 5, 2005
    #6
    I don't use Excel. I don't know if the Mac version uses the same shortcuts as the Windows version.

    On Mac laptops, the end key is accessed using fn-right arrow.

    Pierre Bernard
    http://www.houdah.com
     
  7. gloubibou macrumors member

    Joined:
    Jun 5, 2005
    #7
    Just had a look at the Help book in Excel 2004. There is a very long page on keyboard shortcuts.

    I also gave cmd-right arrow a try. It moves between non-empty cells.

    Pierre Bernard
    http://www.houdah.com
     
  8. GGJstudios thread starter macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #8
    That appears to work. Thanks! That's what I was looking for! I had searched Excel 2008's help, but found only references to the End key, never a description of how to access it without the key appearing on the keyboard.
     
  9. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #9
    I dunno, but looks like we both said the same thing. I didn't try to find a menu method for doing what you want to do on your spreadsheet. That's what I meant, not a menu item that is an End key.
     
  10. GGJstudios thread starter macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #10
    The point is, my question was how to access the End key function, not how to create a keyboard shortcut. gloubibou gave me the answer I needed.
     
  11. theLimit macrumors 6502a

    theLimit

    Joined:
    Jan 30, 2007
    Location:
    up tha holler, acrost tha crick
    #11
    I swear this used to be printed on the keys. Maybe I just imagined it.

    fn + left arrow = home
    fn + right arrow = end
    fn + up arrow = page up
    fn + down arrow = page down
    fn + delete = forward delete

    I find all of these useful every day.
     
  12. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #12
    Yes, I know. Glad you got the answer you really wanted. I was merely taking another approach in case that wasn't possible. You're quite welcome. Oh, wait...
     

Share This Page