Tuesday, July 13, 2010

Microsoft Excel shortcut keys

Shortcut Keys Description
F2 Edit the selected cell.
F5 Goto a specific cell. For example, C6.
F7 Spell check selected text and/or document.
F11 Create chart.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
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.




he below basic shortcut keys are a listing of shortcut keys that will work with almost all IBM compatible computers and software programs. It is highly recommended that all users keep a good reference of the below short cut keys and/or try to memorize the below keys. Doing so will dramatically increase your productivity.
Shortcut Keys Description
Alt + F File menu options in current program.
Alt + E Edit options in current program
F1 Universal Help in almost every Windows program.
Ctrl + A Select all text.
Ctrl + X Cut selected item.

Shift + Del Cut selected item.
Ctrl + C Copy selected item.

Ctrl + Ins Copy selected item
Ctrl + V Paste

Shift + Ins Paste
Home Goes to beginning of current line.
Ctrl + Home Goes to beginning of document.
End Goes to end of current line.
Ctrl + End Goes to end of document.
Shift + Home Highlights from current position to beginning of line.
Shift + End Highlights from current position to end of line.
Ctrl + Left arrow Moves one word to the left at a time.
Ctrl + Right arrow Moves one word to the right at a time.


Microsoft FrontPage shortcut keys
Below is a listing of all the major shortcut keys in Microsoft FrontPage. See our main shortcut page if you're looking for other shortcut keys used in other programs.
Shortcut Keys Description
Ctrl + C Copy selected text.

Ctrl + X Cut selected text.

Ctrl + P Paste selected text.

Ctrl + K Create a hyperlink.

Ctrl + B Bold highlighted selection.

Ctrl + I Italic highlighted selection.

Ctrl + U Underline highlighted selection.
Ctrl + L Left align the text.

Ctrl + R Right align the text.
Ctrl + E Center the text.
Ctrl + / Turn on or off the display of HTML tags.

Ctrl + S Save document.
Ctrl + Tab Switch between open web pages.
Ctrl + Ins Enter Line break.
Ctrl + Enter Move cursor above or below a table.
Ctrl + Shift + B Preview in web browser window.
Ctrl + Shift + < Decrease font size. Ctrl + Shift + > Increase font size.
Ctrl + Del Deletes word to right of cursor.
Ctrl + Backspace Deletes word to left of cursor.
Alt + mouse double-click
View the properties of a selected item. For example, doing this on a table cell would display the properties for that cell.

No comments:

Post a Comment