Must Read Guide: How To Hack Any Android And iPhone (including Gmail,Facebook,Twitter,Whatsapp etc)

51 shortcuts keys for Microsoft Excel 2016

By
Advertisement




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.