Site Loader
Get a Quote
MS Excel Shortcuts Keys
MS Excel Shortcuts Keys

MS Excel Shortcuts Keys

MS Excel Shortcuts Keys: – MS Excel(Microsoft Excel) is a spreadsheet which allows users to create, organize and calculate data on a formula basis.It Is developed by Microsoft company for Windows, macOS, Android, and iOS. It has unique features calculation, graphing tools, pivot tables, and a macro programming language, which We use for a Programming language like Visual Basic.Here we start a topic on MS Excel Shortcuts Keys

Developer(s) Company Microsoft CO
Initial release September 30, 1985
Stable release
2016 (16.0.6769.2017)
OS Working Microsoft Windows, MAC
Type Spreadsheet
License Trialware(Commercial)
Website office.microsoft.com/en-us/excel

 

MS Excel  Shortcuts Keys Commands

We have explained all the commands for MS Excel  Shortcuts Keys and their explanation

 

MS Excel shortcuts  keys MS Excel shortcuts Description
F2 This MS Excel shortcuts Edit the selected cell in Spreadsheet.
F3 When a user creates names, F3 will paste names.
F4 It Repeats the last action the of the user. For example, if you changed the value of the text in another cell, pressing F4 will change the text in a cell to the same value .
F5 This will Go to a specific cell. For example, C9.
F7 It checks the spelling of selected text or all document
F11 Using this you can create chart on the basis of selected text
Ctrl + Shift + ; It  Enter the current time in cell.
Ctrl + ; It enters the current date in the cell.
Alt + Shift + F1 This will insert the new worksheet in the current worksheet
Alt + Enter While typing text in a cell, pressing Alt + Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up the search box.
Ctrl + 1 Open the Format Cells window in a spreadsheet.
Ctrl + A Select all contents of the spreadsheet.
Ctrl + B It Bold highlighted a selection of text.
Ctrl + I It Italic highlighted a selection of text.
Ctrl + K This MS Excel shortcuts will  Insert link in documents.
Ctrl + S This MS Excel shortcuts will Save the open worksheet.
Ctrl + U This MS Excel shortcuts will Underline highlighted the selection.
Ctrl + 1 This MS Excel shortcuts will  Change the format of selected cells.
Ctrl + 5 This MS Excel shortcuts will  Strikethrough highlighted the selection.
Ctrl + P This MS Excel shortcuts will  Bring up the print dialog box to begin the printing process.
Ctrl + Z This MS Excel shortcuts will Undo the last action.
Ctrl + F3 Open Excel Name Manager.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks or windows.
Ctrl + Page up Move between worksheets in the same document.
Ctrl + Page down Move between worksheets in the same document.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = Create a formula to sum all of the above cells.
Ctrl + ‘ Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + 1  This MS Excel shortcuts will Format number in comma format.
Ctrl + Shift + 4 This MS Excel shortcuts will Format number in currency format.
Ctrl + Shift + 3 This MS Excel shortcuts will Format number in date format.
Ctrl + Shift + 5 This MS Excel shortcuts will Format number in a percentage format.
Ctrl + Shift + 6 This MS Excel shortcut will Format number in scientific format.
Ctrl + Shift + 2 This MS Excel shortcut will Format number in time format.
Ctrl + Arrow key This MS Excel shortcut will  Move to next section of text in a worksheet.
Ctrl + Space This MS Excel shortcut will  Select all column in the worksheet.
Shift + Space This MS Excel shortcut will  Select all row in the worksheet.
Ctrl + – This MS Excel shortcut will Delete the selected column or row in the worksheet.
Ctrl + Shift + = This MS Excel shortcut will  Insert a new column or row in the worksheet.
Ctrl + Home This MS Excel shortcut will  Move to cell B1.
Ctrl + ~ This MS Excel shortcut will  Switch between showing Excel formulas or their values in cells.

I hope you would like this topic on MS Excel  Shortcuts Keys

Post Author: TechieFlair

Leave a Reply

Your email address will not be published.