51 shortcuts keys for Microsoft Excel

51 shortcuts keys for Microsoft Excel

by Malik korrich ~ samedi 7 mars 2015

we collect all usefull shorcut keywords for microsoft excel .The followings are Microsoft Excel

shortcuts. Some short-cuts might be version specific.so don't confused.
here we divide this srticle in two parts

1) mouse shorcuts and
2) keyboard shortcuts
 
1) Mouse shortcuts:
(1)  Double-click (on a cell)     Edit the cell contents.

(2)  Double-click (on a row/column divider)     Adjust height/width to auto-fit


(3)  High-light headers of multiple rows/columns then Double-click on a row/column divider    
Adjust height/width to auto-fit of all high-lighted rows/columns


(4) Triple-click     Select the entire contents in the cell

(5) Click on row/column divider then drag     Adjust height/width of the row/colunn


(6)  High-light headers of multiple rows/columns then Click on row/column divider then drag    
Adjust height/width of the rows/colunns


(7)  Ctrl + Mouse wheel     Zooms in and out of document.

(8)  Hold Shift + Click the cells     Select multiple cells

2) Keyboard shortcuts:

(1)  F2     Edit the selected cell.

(2)  F5     Goto a specific cell. For example, C6.

(3)  F7     Spell check selected text and/or document.

(4)  F11     Create chart.

(5)  Ctrl + A     Select all.

(6)  Ctrl + B     Bold.

(7)  Ctrl + C     Copy.

(8)  Ctrl + F     Find (same as Shift + F5).

(9)  Ctrl + G     Go To.

(10)  Ctrl + H     Replace.

(11)  Ctrl + I     Italic.

(12)  Ctrl + K     Insert link.

(13)  Ctrl + N     New Workbook.

(14)  Ctrl + O     Open Workbook.

(15)  Ctrl + P     Print dialog.

(16)  Ctrl + S     Save.

(17)  Ctrl + U     Underline.

(18)  Ctrl + V     Paste.

(19)  Ctrl + Z     Undo.

(20)  Ctrl + Y     Redo.

(21)  Ctrl + X     Cut.

(22)  Ctrl + 5     Strikethrough text.

(23)  Ctrl + F3     Define Name.

(24) Ctrl + F4     Exit Excel.

(25) Ctrl + F6     Switch between open workbooks.

(26)  Ctrl + F9     Minimize current window.

(27)  Ctrl + F10     Maximize current window.

(28)  Shift + F1     Activate Help on Item.

(29)  Shift + F2     Insert Comments


(30)  Shift + F3     Insert Function.

(31)  Ctrl + Shift + ;     Enter the current time.

(32)  Ctrl + ;     Enter the current date.

(33) Ctrl + Page down     Move to next worksheet.

(34)  Ctrl + Page up     Move to previous worksheet.

(35)  Ctrl + Shift + #     Number Format: Date

(36)  Ctrl + Shift + @     Number Format: Time.

(37)  Ctrl + Shift + !     Number Format: Commas.

(38)  Ctrl + Shift + $     Number Format: Currency

(39)  Ctrl + Shift + %     Number Format: Percentage

(40)  Ctrl + Shift + ^     Number Format: Scientific.

(41)  Ctrl + Space     Select entire column.

(42)  Shift + Space     Select entire row.

(43)  Ctrl + (Arrow key)     Move to next section.