For those who work with the windows program Excel....?

What are some quick short cuts to use in the program? Ctrl,D lets you add the same number numorous numbers in a column. Anymore?

вєи2008-06-12T02:39:51Z

Favorite Answer

[Ctrl]+[+] (use + in the numpad or [shift]+[=]) inserts a new row
[Ctrl]+[-] deletes a row.
[Ctrl]+[1] opens up the format cells window (same as right-click a cell, select format cells...)
[Ctrl]+[R] find window (Ctrl+H for Find & Replace)
F4 repeats your last action
[Ctrl]+[9] hides the selected rows ([Ctrl]+[shift]+[9] unhides the rows)
[Ctrl]+[0] hides the selected columns ([Ctrl]+[shift]+[0] unhides the columns)
[Ctrl]+[T] or [Ctrl]+[L] creates a table
[Ctrl]+[G] or [F2] opens up go to
[Ctrl]+[;] insert todays date & [Ctrl]+[Shift]+[;] inserts current time

F2 Edit the selected cell.
F7 Spell check selected text and/or document.
F11 Create chart.
Alt + Shift + F1 Insert New Worksheet.
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up search box.
Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + P Bring up the print dialog box to begin printing.
Ctrl + Z Undo last action.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks / windows.
Ctrl + Page up Move between Excel work sheets in the same Excel document.
Ctrl + Page down Move between Excel work sheets in the same Excel document.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = Create a formula to sum all of the above cells
Ctrl + ' Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + ^ Format number in scientific format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space Select entire column.
Shift + Space Select entire row.

Anonymous2008-06-12T02:17:52Z

There are numerous keyboard shortcuts - FAR too many to list for you here -

visit http://www.rnib.org.uk/xpedio/groups/public/documents/publicwebsite/public_rnib003503.hcsp
and
http://www.excelshortcuts.co.uk/pages/rptShortCuts.htm

nard2008-06-12T02:16:28Z

click this links:
http://www.internet4classrooms.com/excel_keyboard_ibm.htm
http://office.tizag.com/excelTutorial/excelshortcuts.php