"End" key function needed

GGJstudios

macrumors Westmere
Original poster
May 16, 2008
44,427
762
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?
 

xUKHCx

Administrator emeritus
Jan 15, 2006
12,587
6
The Kop
Holding command and then using the arrow keys seems to achieve pretty similar results in Excel 2004 on my mac.
 

GGJstudios

macrumors Westmere
Original poster
May 16, 2008
44,427
762
Holding command and then using the arrow keys seems to achieve pretty similar results in Excel 2004 on my mac.
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.
 

gloubibou

macrumors member
Jun 5, 2005
58
1
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
 

gloubibou

macrumors member
Jun 5, 2005
58
1
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
 

GGJstudios

macrumors Westmere
Original poster
May 16, 2008
44,427
762
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
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.
 

GGJstudios

macrumors Westmere
Original poster
May 16, 2008
44,427
762
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.
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.
 

theLimit

macrumors 6502a
Jan 30, 2007
928
1
up tha holler, acrost tha crick
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.
 

Gregg2

macrumors 603
May 22, 2008
5,952
421
Milwaukee, WI
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.
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...
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.