Mac Excel Shortcuts

It turns out that some of the commands in Mac Excel can’t actually be rebound. For instance, Allison, wants to have these work. Here is the list and how to get them Mac Excel. For Mac Excel 2001 we have a list.

Control + page up. This maps to Ctrl-Right which is find the next empty cell. On a Mac laptop there is no Page Up or Page Down keys, they only have arrow keys, so can’t remap these. Need to use an extended 101 keyboard for this to work. The Mac equivalent is Command-F6 and Command-Shift-F6 to go back a worksheet

The function keys are gotten by typing FN-F1 since the Mac uses the function keys for other things:

F2. This is so strange, with the Mac, it maps to Ctrl-U and there is no way to get F2 for EDIT and need a shortcut. You can get this with Quickeys
F4. This is Command-T on the Mac (“techjive”:http://www.techjive.net/2007/02/02/excel-keystrokes/). The only way to get this to work for Excel is some sort of shortcut. You can get this with Quickeys to map it.
F5. This is the Goto function and it works
F9. Recalc which is CMD-W The main issue is that normally Mac Excel makes F9 their own shortcut, so you have to turn off keyboard shortcuts for Expose.

Ctrl-R.Copy from the cell on left into this cell. This works in Mac Excel and is called the Right function
Ctrl-D. Copy from the cell above down to here.
Alt + =. Not sure what this does but on Mac, Alt keys actually puts in special character
Shift+F2. Insert comment. this works in Mac Excel
Alt+E, S, T. Opens the edit menu, then s choose paste specials and then format. You have to get this with Quickeys
Control + 1. Format Cells. Need to change in the Excel Keyboard Shortcuts since it is select object on the Mac and format cells is command-1.

Alt+I+C. Insert Column. Which I actually do as Ctrl-Space and then Ctrl-+, but you need a key remapper to do this.
Alt+I+R. Insert Row. Same thing, but it is actually Ctrl-Shift-Equal
Control+P. Works this is File/Print
Control+Y. This is redo and is mapped to Command-Y on the Mac, but Control-Y is unassigned, so use Excel to map
Control+Tab. This is next workbook. It works in Mac Excel. Note that Alt-Tab on the PC is Command-Taq on the Mac which you need Quickeys can’t remap

Some of my favorites are

Ctrl-$ for currency format. Works on Mac
Ctrl-% for perfentage. Works on Mac
Ctrl-Shift-Arrow. Select to the rigth

Ctrl-PgUp navigates through worksheets
Ctrl-PgDn navigates through worksheets.
Ctrl-Minus is Delect
Ctrl-Shift-Plus is Insert
Ctrl-* is fill in
Shift-Space selects a row
Ctrl-Plus inserts a row
Ctrl-Minus deletes a row

When Players aren’t going to play

If you get a note saying someone doesn’t want to play:

# Get email from the parents or the participant. You can’t just take the coach’s word
# Choose in Quick clicks and assign participant and find the team, click on the person and unassign
# Now reject the player
# Select the main folder for your registration event
# Choose EDIT / FIND and search for your player or coach/volunteer (or team).
# For players (or teams), click on the to display the Registration Financial Information screen.
# When the window displays, by each registrant name you’ll see a CONFIRM or REJECT button. Select the option you want and click the UPDATE STATUS button on that screen.
# When you are done making your changes to EACH registrant on the screen, click the CLOSE button.

Proving Scholarships

Capitol Hill Soccer does provide scholarships for children who want to play for whom the registration would create difficulties for the families. Here’s the process in Bonzi:

# The parents need to register, provide proof of age and so forth
# They should register with a pay by check
# Email registrar explaining the circumstances
# If approved, then the registrar comps the payment and notes to president

The actual process is:

# Click on the active league on the left
# Choose Registration/Registrant/Edit
# Type in the last name and choose find
# You will now see the participants
# Click on Financial Information and you will see the payment so far screen
# Click on New Payment/Refund
# See how the payment is made, if it is credit card and note the amount
# Enter the scholarship amount and then refund it

PC Office Compatibility mode for Mac Office

One of the maddening things about the Mac Office 2004/2008 line is that it is not keystroke compatible with Windows Office. I don’t know why they don’t have a compatibility mode so that for instance Ctrl-+ works (this is insert) or Ctrl– (this is delete) or Shift-Space which is select row, but they don’t. The same with Mac PowerPoint. Ctrl-Right Arrow doesn’t promote. Well, time to go build it. Allison hates it and asked for it, so here is a feature I’ll sell to Microsoft for $20M. Here is the poor man’s way to get keystroke compatibility. (It is way easier than the last time 20 years ago when the analogous feature, 1-2-3 keystroke compatibility was such a big deal for PC Excel. First memo I ever sent up the chain and the memo that should have gotten me fired if Microsoft had been such an extraordinary company back then).

Here is how to do it:

h2. Excel Keystroke Shortcuts

First you need a list of the keystrokes. Amazingly, “Excel”:http://blogs.msdn.com/excel/archive/2006/02/23/538311.aspx has 214 keystroke shortcuts available. It is just for basic editing! So that’s the list that you need. There are some that they are trying to get rid of but everyone needs them. BTW, I’m shooting for Excel 2003 and below compatibility. Excel 2007 of course changed lots of things which I don’t need to fix. Or argue about for that matter.

He has his favorites which are also mine:
* Ctrl + Page Up and Ctrl + Page Down – previous/next worksheet
* Shift + Space – select row
* Ctrl + Space – select column
* Ctrl + 0 – hide column
* Shift + Ctrl + 0 – show column
* Ctrl + 9 – hide row
* Shift + Ctrl + 9 – show row
* Ctrl + ‘ – Copy above cell and edit
* Alt + Down – Open drop-down (auto-complete, filter, pick from list, or validation)
* Ctrl + / – Select Array
* F9 – Calculate
* Shift + F9 – Calculate sheet (in the active workbook)

Then, there are a whole group that relate to selection in Excel – selecting ranges, navigating selection, etc. By way of background, Excel has a few selection “modes” which you can turn on and off. “Extend selection mode”, when turned on, simply expands selection from the active cell when you move around using the mouse or keyboard. “Add selection mode” adds to existing selection when you select cells (using either the mouse or toggling on “Extent selection mode”). These are handy for keyboard-intensive users. Here are some examples.

* F8 – Extend selection mode
* Shift F8 – Add selection mode
* Shift + Backspace – Collapse selection to the active cell
* Ctrl+ Backspace – Show active cell (particularly handy if you have a large range selected and the active cell is off the screen)
* Ctrl + Alt + Left Arrow – Move active cell to previous non-adjacent area within selection (when you have discontinuous ranges selected)
* Ctrl + Alt + Right Arrow – Move active cell to next non-adjacent area within selection (again, when you have discontinuous ranges selected)
* Ctrl + . – rotates the active cell through the corners of a selection
* Enter – move active cell down in a selection
* Shift + Enter – move active cell up in a selection

On to the more esoteric items. Here is one that is less-frequently-used since we added formula tooltips (the tooltips that show the arguments of a formula as you type), but it can still come in handy.

* Shift + Ctrl + A – Insert arguments in formula

And here are a couple of my true favourites which allow you to quickly navigate the “calculation chain” in Excel.

* Ctrl + [ – Select direct precedent cells
* Shift + Ctrl + [ – Select all precedent cells
* Ctrl + ] – Select directly dependent cells
* Shift + Ctrl + ] – Select all dependent cells

There are other lists too like “Official list”:http://office.microsoft.com/en-us/assistance/HP052037811033.aspx and “David Ritchie’s”:http://www.mvps.org/dmcritchie/excel/shortx2k.htm

h2. What are most used

h2. Changing keyboard shortcuts

So how do you change keyboard shortcuts. Well, “macosx.com”:http://macosx.com/forums/mac-os-x-system-mac-software/39064-hidden-key-stroke-short-cuts-ms-excel.html has some tips and also some suggestions:

Hidden Key-stroke short-cuts in MS Excel – macosx.com

Assign a keyboard shortcut

1. On the Tools menu, click Customize.
2. At the bottom of the Customize dialog box, click Keyboard.
3. In the Customize Keyboard dialog box, select a category from the Categories list to see the commands and other items associated with that category.
4. Click the command you want in the list to the right.

Note** If there is currently a keyboard shortcut associated with the command, it is displayed in the Current keys box.
5. Click inside the Press new shortcut key box.
6. Press the key combination you want to use for the command.
7. Click Add.
8. After you have finished assigning all the shortcuts you want, click OK.

Note** If you change your mind now or later, you can reset the shortcuts by clicking Reset All.”

Also, Unsanity has an app to create keyboard shortcuts that you can check out – I haven’t used it yet. I often use QuicKeys – for example, I was so sick of paste special not defualting to unformatted text (what I always seem to want to do) that I created a QuicKeys shortcut for this that I use in Word, Excel and Mail.”

Excel Keystrokes

I use these every time I’m in Excel.

* ctrl-Space – select column
* shift-Space – select row
* ctrl-Arrow Key – depending on which arrow key you hit, it will move the cursor along a series of cells*
* ctrl-Page Up, ctrl-Page Down – cycles through worksheets
* ctrl-Home – selects A1 on the current worksheet

h2. Mac Excel shortcuts

BTW, it turns out that Mac Excel has many identical ones, but they use the Command key instead of the CTRL key. How dumb since the CTRL key isn’t used at all by Mac Excel. Here are some:

XL2001: Shortcut Keys Available in Excel 2001 for Mac (Part 1)

Start a formula Cell, Formula bar = (Equal sign)
Move one character up, down, left, or right Cells, Text boxes ARROW KEYS
Move between options in the active pop-up menu or between some options in a group of options Dialog boxes ARROW KEYS
Move one cell in a given direction Sheets ARROW KEYS
Move around the page when zoomed in (in Print Preview) Print Preview ARROW KEYS
Calculate all sheets in all open workbooks Workbooks COMMAND+= (Equal sign)
Resize cell and show the formula instead of the resulting value. If the cell does not contain a formula, show the value. Options, Display Formula COMMAND+~ (Tilde)
Display the Cells command (Format menu) Workbook COMMAND+1
Select the entire worksheet Worksheet COMMAND+A
Apply or remove bold formatting Cells, Text Boxes, Chart objects, Chart items COMMAND+B
Copy the selection Cell, Range, Object COMMAND+C
Move the selected field into the Column area PivotTable Wizard – Layout dialog box COMMAND+C
Move the selected field into the Data area PivotTable Wizard – Layout dialog box COMMAND+D
Align center Cells, Text boxes COMMAND+E
Display the Find command (Edit menu) Excel COMMAND+F
Switch to the next workbook window Workbook window COMMAND+F6
Display the Replace command (Edit menu) Excel COMMAND+H
Apply or remove italic formatting Cells, Text Boxes, Chart objects, Chart items COMMAND+I
Insert a hyperlink Cell COMMAND+K
Aligns the selection to the left Cells, Text boxes COMMAND+L
Display the PivotTable Field dialog box PivotTable Wizard – Layout dialog box COMMAND+L
Move one word to the left Text box COMMAND+LEFT ARROW
Indent Cell, Range COMMAND+M
Create a new workbook Excel COMMAND+N
Open an existing file Excel COMMAND+O
Remove all borders Cell, Range COMMAND+OPTION+- (Hyphen)
Apply the outline border Cell, Range COMMAND+OPTION+0 (Zero)
Apply/remove the bottom outline border Cell, Range COMMAND+OPTION+DOWN ARROW
Apply/remove the left outline border Cell, Range COMMAND+OPTION+LEFT ARROW
Apply/remove the right outline border Cell, Range COMMAND+OPTION+RIGHT ARROW
Apply/remove the top outline border Cell, Range COMMAND+OPTION+UP ARROW
Display the Print command (File menu) Workbook, Help window COMMAND+P
Move the selected field into the Page area PivotTable Wizard – Layout dialog box COMMAND+P
Quit Excel COMMAND+Q
Aligns the selection to the right Cells, Text boxes COMMAND+R
Move the selected field into the Row area PivotTable Wizard – Layout dialog box COMMAND+R
Move one word to the right Text box COMMAND+RIGHT ARROW
Save Workbook COMMAND+S
Decrease font size Workbook COMMAND+SHIFT+,
Increase font size Cells, Text boxes COMMAND+SHIFT+.
Apply or remove strikethrough formatting Cells, Text boxes COMMAND+SHIFT+- (Hyphen)
Add or remove outline on text Cell, Range COMMAND+SHIFT+D
Switch to the previous workbook window Workbook window COMMAND+SHIFT+F6
Display the Style command (Format menu) Workbook COMMAND+SHIFT+L
Select or unselect one word to the left Cells, Text boxes COMMAND+SHIFT+LEFT ARROW
Unindent (remove indent) Cells, Text boxes COMMAND+SHIFT+M
Select all cells that contain comments Worksheet COMMAND+SHIFT+O
Select or unselect one word to the right Cells, Text boxes COMMAND+SHIFT+RIGHT ARROW
Insert the AutoSum formula Cell, Range COMMAND+SHIFT+T
Display the Paste Special dialog box after Copy command Cell, Range COMMAND+SHIFT+V
Add or remove shadow on text Cell, Range COMMAND+SHIFT+W
Select only visible cells in the current selection Range COMMAND+SHIFT+Z
Toggle cell reference relative or absolute Range COMMAND+T
Select a Help topic from the topics that are displayed by the Office Assistant Assistant Help balloon COMMAND+Topic number (where 1 is the first topic, 2 is the second, and so on)
Apply or remove underline formatting Cells, Text boxes COMMAND+U
Paste the selection Excel COMMAND+V
Close the active workbook window Windows and dialog boxes COMMAND+W
Cut the selection Cell, Range, Object COMMAND+X
Repeat the last action Workbook COMMAND+Y
Undo the last selection Excel COMMAND+Z

h3. What is not right

In Mac Excel 2008, some keys are there and others are missing. Here’s a list of the common ones I use and their status:

Shift-Space. Select Row. It’s there
Ctrl-Space. Select Column. It’s there
Ctrl-Shift-=. Insert. Not there. Can add with the Tools/Customize Keyboard.

Code of conduct forms and process

The Washington State Youth Soccer Association only requires that every player, parent and volunteer agree to the follow its ethics rules (no screaming at kids for instance) simply by participating.

The Seattle Youth Soccer Association requires that parents, players and volunteers sign a form.

At Capitol Hill Soccer Club, we handle this in two ways:

# As part of the registration process for players, electronically, you see an ethics form and agree to it.
# As part of the coach signup process, you also have an ethics form you have to agree to. In addition, we collect a signed coach ethics form as well as a secondary check that everyone really understands the point of this is to make sure kids have fun and learn good sportsmanship
# There is a disciplinary process where if there is an incident, a protesting coach tells the referee. Then with the endorsement of the club president, it goes to the disciplinary committee at the Seattle level. Their decisions are reviewed by the large Seattle club.

What is a parent does not have internet access

The entire registration system is online with Bonzi, unfortunately, there are still people who don’t have Internet access, so what are the choices. Well, there are two, have the person come by your office or home to do a registration with you.

A better one though is to recommend the person go to a nearby library. Libraries in Seattle and King County allow free internet access if you are a resident with a library card. So that’s the best choice.

Windows 32 bit address limits

Hey, I can’t believe we are out of address space again. I lived that way too long ago going from 8 bit (remember when 128KB was an unbelievable amount of money) to 16 bit (remember when 8MB was just ridiculous) to 32 bit (remember when 1GB was a huge amount).

So now those simple decisions. In each case the same trick is done every time which has been called segmented memory or now PAE (physical address extension). Where the operating system knows about lots more memory, the application sets bits that say, I want to look at this segment, this and so forth, so there are segment registers running around that you have to set. Old 80286 programmers spent their lives doing this. For 10 years, this was not an issue, but time marches on.

As he points out, “MSDN”:http://msdn.microsoft.com/en-us/library/aa366778.aspx has the exact limitations which are intensely complicated. There is some structure called IMAGE_FILE_LARGE_ADDRESS_AWARE and also “4-gigabyte tuning (4GT). My head hurts already!

The default is that applications see 4GB total and 2GB are for applications and 2GB are for the system. What “4GT”:http://msdn.microsoft.com/en-us/library/bb613473(VS.85).aspx changes this so application can see 3GB. Of course, you need some custom tool and hack away boot.ini via some utiilty like bcdedit (Boot Configuration Data Editor)

I read the whole thing and I’ve been so far outside of Windows, my head literally hurt between all the versions of Windows and the many parameters you can set.

| Type | 32-bit Windows | 64-bit |
| 32-bit apps | 2GB | 2GB |
| 32-bit apps | 3GB

Other registrars

There are always players switching or you are looking for verification of ages from other clubs. Capitol Hill’s nearest sisters are Mt. Baker and McGilvra clubs and their registrars are on “SYSA”:http://sysa.org so you can contact them that way.

Also there is a Yahoo group that the Seattle registrar Bob keeps going. You can also go to that site and ask questions there.