Recently Added

Most Used Shortcut keys of Microsoft Excel

: 4968

What is Microsoft Excel?

MS Excel is an ordinarily utilized Microsoft Office application. It is a bookkeeping page program that is utilized to spare and examine mathematical information.
MS Excel is broadly utilized for different purposes in light of the fact that the information is anything but difficult to spare, and data can be added and eliminated with no distress and less difficult work.
Developer: Microsoft Corporation
Written in: C#, C++, Microsoft Foundation Class Library, .NET Framework

Most used shortcut keys for Microsoft Excel

Excel shortcut keys
F2	Edit the selected cell.
F5	Go to a specific cell.
F7	Spell check selected text and/or document.
F11	Create chart
Ctrl + Shift + ;	Enter the current time.
Ctrl + ;	Enter the current date
Alt + Shift + F1	Insert a new worksheet.
Shift + F3	Open the Excel formula window.
Shift + F5	Bring up the search box
Ctrl + A	Select all contents of a worksheet.
Ctrl + B	Bold highlighted selection.
Ctrl + I	Italicize highlighted selection.
Ctrl + C	Copy selected text.
Ctrl + V	Paste
Ctrl + D	Fill
Ctrl + K	Insert link
Ctrl + F	Open find and replace options.
Ctrl + G	Open go-to options.
Ctrl + H	Open find and replace options.
Ctrl + U	Underline highlighted selection.
Ctrl + Y	Underline selected text.
Ctrl + 5	Strikethrough highlighted selection.
Ctrl + O	Open options.
Ctrl + N	Open a new document.
Ctrl + P	Open print dialog box.
Ctrl + S	Save.
Ctrl + Z	Undo the last action.
Ctrl + F9	Minimize the current window.
Ctrl + F10	Maximize the currently selected window.
Ctrl + F6	Switch between open workbooks/windows.
Ctrl + Page up & Page Down	Move between Excel worksheets in the same document.
Ctrl + Tab	Move between two or more open Excel files
Alt + =	Create the formula to sum all of the above cells.
Ctrl +	Insert the value of the above cell into the current cell.
Ctrl + Shift + !	Format number in comma format.
Ctrl + Shift + $	Format number in currency format.
Ctrl + Shift + #	Format number in date format.
Ctrl + Shift + %	Format number in a percentage format.
Ctrl + Shift + ^	Format number in scientific format.
Ctrl + Shift + @	Format number in time format.
Ctrl + (Right arrow)	Move to the next section of the text.
Ctrl + Space	Select the entire column.
Shift + Space	Select the entire row.
Ctrl + W	Close document.

Benefits of Microsoft Excel

Simple To Store Data: Since there is no restriction to the measure of data that can be spared in an accounting page, MS Excel is generally used to spare information or to investigate information. Sifting data in Excel is simple and advantageous.
Simple To Recover Data: If the data is composed on a bit of paper, discovering it might take longer, be that as it may, this isn't the situation with dominant bookkeeping pages. Finding and recuperating information is simple.
Utilization of Mathematical Formulas: Doing counts has become simpler and less time chatting with the recipes choice in MS dominate
Safer: These bookkeeping pages can be the secret word made sure about in a PC or PC and the likelihood of losing them is route lesser in contrast with information written in registers or bits of paper.
Information at One Place: Earlier, information was to be kept in various documents and registers when the administrative work was finished. Presently, this has gotten helpful as beyond what one worksheet can be included a solitary MS Excel record.
Neater and Clearer Visibility of Information: When the information is spared as a table, dissecting it gets simpler. Hence, data is a bookkeeping page that is more coherent and reasonable.