Help with shortcuts

If it is a menu item, you can add it in via the *Keyboard & Mouse* preference panel.

This works for all OSX applications and menus.

I gave detailed instructions on doing this several times. Look in the Pages '08 forum.

Peter

Excel has a ton of shortcuts (though the default for Date is Control+Semicolon in the version I have). There seems to be a shortcut in Excel for pretty much anything you might want to do, if you can remember them. Numbers does not have many and does not have the two you are asking about.

You should be able to create a shortcut for "insert data and time" in System Preferences/Keyboard and Mouse/Keyboard Shortcuts. It will end up inserting only the date (today's date) if the cell format is "automatic".

The "copy value from above" shortcut is unavailable. Best I can come up with right now is Up Arrow, Cmd-C, Down Arrow, Cmd-V.

An entire list of shortcuts can be found at Help/Keyboard Shortcuts

Here are the instructions from the help file:

To create a keyboard shortcut for an application:

Choose Apple menu > System Preferences, and then click Keyboard & Mouse.

Click Keyboard Shortcuts, and then click the Add ➕ button.

Choose an application from the Application pop-up menu. If you want to set the same key combination for a menu command that appears in many applications, choose All Applications.

If the application you want to select does not appear in the list, choose Other and locate the application using the Open dialog. Some applications may not allow you to set keyboard shortcuts.

Type the menu command for which you want to set a keyboard shortcut in the Menu Title field.

You must type the command exactly as it appears in the application menu, including ellipses and any other punctuation. An ellipsis is a special character that looks like three periods. To type an ellipsis, press Option-semicolon, or use the Character Palette. It may be difficult to know whether the command is written in the menu with a real ellipsis or with three periods, so if one does not work, try the other.

Click in the Keyboard Shortcut field and press the key combination that you want to assign to the menu command, and then click Add.

You cannot use each type of key (for example, a letter key) more than once in a key combination.

Quit the application for which you added or changed a keyboard shortcut.

Restart the application to see the keyboard shortcut in the application’s menu.

Paul Daly wrote:
I'd appreciate it if someone could provide me with some information which would help me answer my question.

Thought I had.

Peter's comments were applicable. A lot of folks don't know that you can create keyboard shortcuts for pretty much anything in the menu system. Date & Time is in the Insert menu. If you create a shortcut for it you've solved one of your two shortcut problems.

I should note that when you insert date & time, don't get freaked at first when it puts the time as well as the date in the cell. If the cell is formatted as "automatic" or as "date & time" with time set to "none", the time will go away.

Paul Daly wrote:
really? ok. Whatever.

That Joisey attitood will get you far.