Where are Home, End, Page Up, Page Down on MBP keyboard?

Question

Level 1

8 points

Where are Home, End, Page Up, Page Down on MBP keyboard?

I just bought a MBP-15 after spending my entire computer life with Windows. I have a fairly sophisticated spreadsheet that I created in Excel that I now want to use in Numbers. But I'm hung up on the simplest thing - Home & End. I've read other postings and guides related to the keyboard, but everyone else seems to indicate that there are already Home & End keys (and Page Up/Page Down keys) on the keyboard. I have none - at least none that I can find. I just have the standard MBP keyboard, including the F1-F12 function keys (plus fn, option, control, command, & arrows). All of the key remapping posts talk about their use in text like a Safari e-mail. For spreadsheets, Windows lets me take a formula in 1 cell, ctrl-c to copy it, then shift-end-down and ctrl-v to paste that new formula to the end of the existing column. How is this done in the Mac world? Very frustrating so far. If it matters, I'm using Numbers '09 with Lion. Any and all help appreciated.

MacBook Pro, Mac OS X (10.7)

Posted on Sep 12, 2011 9:38 AM

Reply

Answer 1

KOENIG Yvan

Level 8

41,819 points

Sep 12, 2011 9:53 AM in response to rossepeo

http://support.apple.com/kb/HT4773

Yvan KOENIG (VALLAURIS, France) lundi 12 septembre 2011 18:52:59

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

Reply

Answer 2

TheDave413

Level 4

1,012 points

Sep 12, 2011 9:48 AM in response to rossepeo

In the case of keyboard shortcuts for things like Copy and Paste, use the command key (has the little "cloverleaf" icon on it, maybe an Apple icon too). The associated letters are the same, so Copy is cmd-C, Paste is cmd-V, etc.

Reply

Answer 3

Barry

Level 9

60,023 points

Sep 12, 2011 11:37 AM in response to rossepeo

Home: fn-left arrow

End: fn-right arrow

Page Up: fn-up arrow

Page down: fn-down arrow

Actions in Numbers may not match those in Excel.

"For spreadsheets, Windows lets me take a formula in 1 cell, ctrl-c to copy it, then shift-end-down and ctrl-v to paste that new formula to the end of the existing column."

(Enter and confirm the formula in the initial cell if it's not already there.)

Select the initial cell.

Scroll to the bottom row using the thumb on the vertical scroll bar.

Shift-click on the bottom cell to select it and all cells between it and the initial cell.

Go Insert > Fill> Fill Down.

OR

Select the initial cell (containing the formula)

Copy (command-C)

Scroll to the last cell as above.

Shift-click on the last cell.

Paste (command-V)

Numbers design model favors documents containing several small single purpose tables, not large ones. The maximum size of an individual table is 255 columns by 65355 rows. In practical terms, then limits are much smaller in terms of deteriorating performance speed.

Regards,

Barry

Reply

Answer 4

Barry

Level 9

60,023 points

Sep 12, 2011 9:56 PM in response to rossepeo

For keyboard layout questions, you might want to take a look at Keyboard Viewer. On my iBook it's part of the International pane in System Preferences, but that's a few systems ago, so that pane may have a different name.

For Keyboard Shortcuts, check the Help menu in the Finder.

Regards,

Barry

Reply

Answer 5

rossepeo Author

Level 1

8 points

Sep 12, 2011 6:03 PM in response to Barry

Thanks for the help. Still trying to get my head wrapped around what's the same & what's different between Mac and PC.

Reply