ms excel shortcut keys a2z for Success in Examinations

Share this article to your friends

ms excel shortcut keys – computer shortcut keys a 2 z for Success in Examinations

ms excel shortcut keys are very important keys & every person who willing to learn computer should learn ms excel shortcut keys

some of important ms excel shortcut keys are given with here to learn with explanation.

(ms excel shortcut keys marked with * are very important & should be remember)

ms excel shortcut keys

Ctrl+Shift + ; —> This shortcut key is used to insert the current time.      *
Ctrl+; —> This shortcut key is used to enter the current date.      *
Shift + F3 —> This ms excel shortcut key is used to open the Excel formula’s window.      *
Shift + F5 — >   This gives us the option to display the find and replace dialog box.      *
Ctrl + A —> This ms excel shortcut key is used to select or highlight all contents of a worksheet.      *
Ctrl + B —> It allows us to bold all selected items of an Excel sheet. Alternative shortcut key : Ctrl+2      *
Ctrl + C —> This shortcut key is used to copy the selected content of a worksheet.      *
Ctrl + D —> This ms excel shortcut keys allow us to fill down the cells with the content of the selected cell.      *
Ctrl + F —> this short cut key gives the option to open find and replace dialog box quickly. Alternative shortcut key : Shift + F5       *
Ctrl + G —> This shortcut key is used to open the go-to option dialog box where we can go to the specific cell. Alternative shortcut key : F5.      *
Ctrl + H —> It allows us to find and replace the word or sentences in a file.      *

For example, if by mistake we have written a somputer instead of the computer at many places in our sheet, we can replace it with the computer in one go.

Ctrl + I —> This shortcut key is used to put italics on all cells in the selected section. Alternative shortcut key : Ctrl+3.
Ctrl + K It provides the option to insert a hyperlink in a file.      *
Ctrl + L —> This ms excel shortcut keys allow us to access the create table dialog box.
Ctrl + N —> This ms excel shortcut key is used to open the new document or a workbook.
Ctrl + O —> this short cut key gives users the option to open the dialog box where we can choose a file that we want to open. Alternative shortcut key : Ctrl+F12 to open a file.    *
Ctrl + P —> It allows us to print a current sheet or a document quickly.    *
Ctrl + Q —> This shortcut key is used to display the quick analysis options for the selected cells with data.
Ctrl + R —> It allows us to fill the cells to the right with the content of the selected cell.     *
Ctrl + S —> This ms excel shortcut key is used to save the document. Alternative key : Alt+Shift+F2.
Ctrl + T —> this short cut key gives users the option to display the create table dialog box.
Ctrl + U —> This shortcut key is used to underline all selected cells. We can also use the shortcut key Ctrl+4 to underline the cells in the Excel sheet.    *
Ctrl + V — >   This gives us the option to paste the copied data onto the Excel sheet. We are required to copy the data once, and then we can paste it any number of times.    *
Ctrl + W —> This shortcut key is used to close the currently open document or a file quickly. Alternative shortcut key : Ctrl+F4 shortcut keys.    *
Ctrl + X —> this ms excel shortcut key gives the option to cut the entire data of the selected cells in an Excel sheet.    *
Ctrl + Y — >   This gives us the option to redo any undo contents.    *
Ctrl + Z —> This shortcut key is used to undo (get back) the deleted item.

For example, if we have deleted the data by mistake, we can press Ctrl+Z to retrieve the deleted data. Alternative shortcut key : Alt+Backspace.    *

Ctrl + Page up & Page Down —> It allows us to move from one worksheet to another worksheet in the same Excel file.
Ctrl + F6 —> this shortcut key is used to  move from one document to another document in Microsoft Excel. Alternative shortcut key : Ctrl+Tab.
Ctrl + F9 —> this ms excel shortcut key gives the option to minimize the current window.    *
Ctrl + F10 —> it is used to  maximize the currently selected window.    *
F1 —> This shortcut key is used to open the help screen window.    *
F2 —> It allows us to edit the selected cell in the Excel sheet.    *
F4 — >   This gives us the option to repeat the last action.

For example, if we change the font of the text in a cell, by pressing F4, we can apply the same font in another cell.    *

F7 —> This shortcut key is used to check the spelling of the selected text.    *
F10 The function key F10 is used to activate the menu bar. For example, if we want to open the file menu, we need to press F10, then F.
F11 —> This ms excel shortcut key is used to create a chart in Excel.
F12 —> This ms excel shortcut keys allow us to use the Save As option, which allows we to save a file with a different name. Alternative key : Alt+F2.
Alt + = —> It allows us to use the formula to add the data of all the above cells.
Ctrl+Shift+” —> It allows us to copy the content of a cell and to paste it into a cell, which is just below it. Alternative key : Ctrl+” key.

For example, if we have written “Excel” in cell B1 and its below cell is B2, by pressing Ctrl+Shift+” or Ctrl+’ the word “Excel” will be copied in cell B2.

Ctrl + Shift + ! —> This shortcut key is used to apply comma format in numbers.
Ctrl + Shift + $ —> This ms excel shortcut key is used to apply currency format to numbers.
Ctrl + Shift +% — >   This gives us the option to apply percentage sign to numbers.
Ctrl + Space —> This ms excel shortcut keys allow us to select the entire active columns.
Shift + Space —> This ms excel shortcut keys allow us to select the entire active rows.
Ctrl + (Right arrow →) —> this ms excel shortcut key is used to to move the cursor to the next cell, which contains the text.
Ctrl + 1 —> This shortcut key is used to open the format cells dialog box where we can change the text format like text color, font size, font style, text alignment, etc. Alternative shortcut key : Ctrl+Shift+F or Ctrl+Shift+P.
Ctrl + 5 —> This ms excel shortcut key is used to put the strikethrough to all selected cells.
Ctrl + 9 —> This ms excel shortcut key is used to hide the selected rows in the worksheet.
Ctrl + Shift + ( —> This ms excel shortcut key is used to show (unhide) the hidden rows.
Ctrl + 0 —> This shortcut key is used to hide the selected columns.
Ctrl + – (Minus) —>   it is used to  delete dialog box where we can delete a selected row or column.
Ctrl + Shift + = —> by this we can insert dialog box where we can insert the new row or a column.
Ctrl + Shift + ^ —> This shortcut key is used to make an exponential form of any number. For example, we have written a number 123456789  in the worksheet and if we press Ctrl+shift+^ (^ is placed at the upper side of the button of digit 6 ) the number will be changed 1.23E+08 in exponential form.
Ctrl + Shift + & —> this short cut key gives users the option to make a border around the selected cells.
Ctrl + Shift+ _ —> this short cut key gives users the option to remove a border around the selected cells in a worksheet.
Ctrl+Shift+Spacebar —> This shortcut key is used to select the entire worksheet.
Ctrl + Home —> this ms excel shortcut key is used to move the cursor to the beginning (cell A1) of the worksheet.
Ctrl + End —> This shortcut key is used to move the cursor to the last cell with text on the worksheet.
Shift + Page Up —> It allows us to select all the cells located above the selected cell.
Shift + Home —> This ms excel shortcut keys allow us to select all cells to the left of the current active cell.
Shift + (Up Arrow ↑) —> This ms excel shortcut keys allow us to extend the selected area up by one cell.
Shift + (Down Arrow ↑) —> This ms excel shortcut keys allow us to extend the selected area down by one cell.
Alt + Enter —> this ms excel shortcut key is used to to write in multiple lines in one cell.

For example, if we are typing in a cell, —> This ms excel shortcut keys allow us to move on the next line in one cell by pressing Alt+Enter.

Alt + ‘ —> This shortcut key is used to access the style dialog box.
Ctrl + F3 —> This shortcut key is used to open the name manager in Microsoft excel.
Ctrl + F5 —> This ms excel shortcut key is used to restore the Window size.
Ctrl + F11 —> This shortcut key is used to insert a macro sheet in Microsoft excel.
Alt + F8 —> This shortcut key is used to display the macro dialog box.
Alt + F11 — >   This gives us the option to open the Visual Basic editor.
Alt + Shift + F1 —> This ms excel shortcut keys allow us to create a new worksheet in Microsoft Excel

ms excel shortcut keys

ms excel shortcut keys

Also Read : ms word shortcut keys – computer shortcut keys a2z gives Success in Examinations

***************************

Also Read : ms word shortcut keys – computer shortcut keys a2z gives Success in Examinations in Hindi 

***************************

Also Read : Computer shortcut keys for Windows & others a2z

***************************

Share this article to your friends