7.19.2011

Microsoft Excel shortcut keys

Below is a listing of all the major shortcut keys in Microsoft Excel. See the computer shortcut page if you are looking for other shortcut keys used in other programs.



ShortcutDescription

Ctrl + ASelects the entire contents of the worksheet (select all)

Ctrl + BMaking Bold areas / selected cell

Ctrl + IMake italic areas / selected cell

Ctrl + KInserting a link.

Ctrl + UMaking the bottom line area / cell selected

Ctrl + PDisplays the print dialog box to begin printing.

Ctrl + ZUndo / last action.

F2Edit the selected cell

F5Go to a specific cell. For example, E7.

Shift + F5Bring up search box

F7Spell-check selected text and / or documents

F11Creating a Chart

Shift + F3Opening the Excel formula window

Ctrl + Shift +;Enter the current time.

Ctrl +;Enter the date.

Alt + Shift + F1Creating a new Worksheet.

Ctrl + 5make strikethrough cells / selected area

Ctrl + F9Minimize window window

Ctrl + F10Maximize the window window

Ctrl + F6Switching between excel file is opened

Ctrl + Page upSelecting a Sheet to the left

Ctrl + Page DownSelecting the right direction Sheet

Ctrl + TabSwitching between two or more files are open Exel

Alt + =Creating a formula to sum ​​all cells above

Ctrl + 'Entering a value above into the selected cells.

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 keysMove to next section of text.

Ctrl + SpaceSelect the entire column.

Shift + SpaceSelect the entire row.

1 comment:

  1. I’ve learned a lot of useful information from this article. Excel may seem an easy to work with program, but it definitely has its details and specific issues.

    ReplyDelete