Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

GGJstudios

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