[OVERLINE]Keyboard Shortcuts for Microsoft Excel[/OVERLINE]


Ctrl + O
Open existing file Ctrl + N Create new workbook Ctrl + S Save current workbook Ctrl + F4 Close current workbook Ctrl + Z Undo last action Ctrl + Y Redo last action Ctrl + C Copy selection Ctrl + X Cut selection Ctrl + V Paste selction Ctrl + P Print (displays print menu and options) Ctrl + S Save file F12 Save file as
Enter Complete cell data entry and move to cell below. Ctrl + Shift + Enter Enter/create array formula Alt + Enter Start new line in the same cell. Ctrl + Enter Fill selected cell range with current entry. Shift + Enter Complete cell data entry and move to cell directly above current cell. Tab Complete cell data entry and move to the cell to the right. Shift + Tab Complete cell data entry and move to the cell to the left. Esc Cancel a cell entry and go back to what was there before. Arrow Keys Move one cell left, right, up, or down. Home Move to the first column (A). F4 / Ctrl + Y Repeat last action. Ctrl + Shift + F3 Create names for row and column labels. Ctrl + D Fill down. Ctrl + R Fill to the right. Ctrl + F3 Define a name for a cell or range of cells. Ctrl + K Insert a hyperlink. Enter (after insertion of hyperlink) Activate a hyperlink. Ctrl + ; Enter the current date. Ctrl + Shift + : Enter the current time. Alt + Down Arrow Display a drop-down list of the values in the current column of a list. Ctrl + Z Undo the last action. Alt + F8 Displays macro dialog box. Alt + F11 Displays the visual basic editor. Ctrl + F11 Inserts an Excel 4.0 macro sheet. Alt + ' Display style dialog box. Ctrl + 1 Display format cells dialog box. Shift + Spacebar Highlight row Ctrl + Spacebar Highlight column Ctrl + Shift + ~ Apply the 'general number' format to selected cells. Ctrl + Shift + $ Apply the 'currency number' format with two decimal places and negative numbers showing in parentheses to selected cells. Ctrl + Shift + % Apply the 'percentage' format with no decimal places to selected cells. Ctrl + Shift + ^ Apply the 'exponential number' format with two decimal places to selected cells. Ctrl + Shift + # Apply the 'date' format with the day, month, and year to selected cells. Ctrl + Shift + @ Apply the 'time' format with the hour, minute, and AM or PM to selected cells. Ctrl + Shift +! Apply the 'number' format with two decimal places, thousands seperator, and minus sign for negative numbers to selected cells. Ctrl + B Apply/remove bold format to selected cells. Ctrl + I Apply/remove italic format to selected cells. Ctrl + U Apply/remove underline to selected cells. Ctrl + 5 Apply or remove 'strikethrough' to selected cells. Ctrl + 8 Displays or hides the outline of symbols. Ctrl + 9 Hide row. Ctrl + Shift + 9 Unhide row. Ctrl + Shift + ( Unhide any hidden rows within the selection. Ctrl + 0 Hide the selected columns. Ctrl + Shift + ) Unhide any columns within the selection. Ctrl + Shift + & Apply the 'border outline' to selcted cells. Ctrl + Shift + _ Remove the 'border outline' from selected cells. Alt + Shift + Right Arrow Groups selected rows or columns. Alt + Shift + Left Arrow Ungroups selected rows or columns. Alt + F8 Displays macro dialog box. Alt + F11 Displays the visual basic editor. Ctrl + F11 Inserts an Excel 4.0 macro sheet.