The world is a global village and ICT is the village square.
Do things faster with increased accuracy.
Below is the list of all the major shortcut keys in
Microsoft Excel.
Ctrl + A : Selects all contents of the worksheet.
Ctrl + B : Bold highlighted selection.
Ctrl + I : Italicizes the highlighted selection.
Ctrl + K : Inserts
link.
Ctrl + U : Underlines the highlighted selection.
Ctrl + 1 : Changes the format of selected cells.
Ctrl + 5 : Strikethrough the highlighted selection.
Ctrl + P : Brings
up the print dialog box to begin printing.
Ctrl + Z : Undo
last action.
Ctrl + F3 : Opens
Excel Name Manager.
Ctrl + F9: Minimizes the current window.
Ctrl + F10 : Maximizes the currently selected window.
Ctrl + F6 : Switches between open workbooks or windows.
Ctrl + Page up :
Moves between Excel work sheets in the same Excel document.
Ctrl + Page down : Moves between Excel work sheets in the
same Excel document.
Ctrl + Tab : Moves
between Two or more open Excel files.
Alt + = : Creates a formula to sum all of the above cells
Ctrl + ' : Inserts the value of the above cell into cell
currently selected.
Ctrl + Shift + ! :
Formats the number in comma format.
Ctrl + Shift + $ : Formats the number in currency format.
Ctrl + Shift + # :
Formats the number in date format.
Ctrl + Shift + % : Formats the number in percentage
format.
Ctrl + Shift + ^ : Formats the number in scientific format
. Ctrl + Shift + @ : Formats the number in time format.
Ctrl + Arrow key :
Moves to the next section of text.
Ctrl + Space : Selects the entire column. Shift + Space
: Selects the entire row
Ctrl + - : Deletes the selected column or row.
Ctrl + Shift + = : Inserts a new column or row.