Top 101 + Microsoft Excel shortcut keys - It Clues

In this post i have updated Top best excel short keys to help you work on excel easily. Microsoft excel is use to business purpose to manage your account and store data. Its very useful in business.

Excel shortcuts in image format:

Microsoft Excel shortcut keys
Microsoft Excel shortcut keys

Microsoft Excel short keys 

Ctrl + K Insert link.
F2 Edit the selected cell.
Ctrl + Z Undo last action.
Ctrl + Home Move to cell A1.
Shift + F5 Bring up search box.
Shift + Space Select entire row.
Ctrl + ; Enter the current date.
Ctrl + S Save the open worksheet.
Ctrl + F9 Minimize current window.
Ctrl + Space Select entire column.
Ctrl + F3 Open Excel Name Manager.
Ctrl + B Bold highlighted selection.
F11 Create chart from selected data.
Ctrl + I Italic highlighted selection.
Ctrl + 1 Open the Format Cells window.
Alt + Shift + F1 Insert New Worksheet.
Ctrl + Shift + ; Enter the current time.
Ctrl + U Underline highlighted selection.
Shift + F3 Open the Excel formula window.
F7 Spell check selected text or document.
F5 Go to a specific cell. For example, C6.
Ctrl + - Delete the selected column or row.
Ctrl + Shift + = Insert a new column or row.
Ctrl + 5 Strike through highlighted selection.
Ctrl + 1 Change the format of selected cells.
Ctrl + Shift + 3 Format number in date format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Shift + 2 Format number in time format.
Ctrl + A Select all contents of the worksheet.
Ctrl + F10 Maximize currently selected window.
Ctrl + Shift + 1 Format number in comma format.
Ctrl + Shift + 4 Format number in currency format.
Ctrl + F6 Switch between open workbooks or windows.
Ctrl + Shift + 6 Format number in scientific format.
Ctrl + Shift + 5 Format number in percentage format.
Ctrl + Tab Move between Two or more open Excel files.
F3 After a name has been created, F3 will paste names.
Alt + = Create a formula to sum all of the above cells.
Ctrl + Page up Move between work sheets in the same document.
Ctrl + Page down Move between work sheets in the same document.
Ctrl + P Bring up the print dialog box to begin the printing process.
Ctrl + ~ Switch between showing Excel formulas or their values in cells.
Ctrl + ' Insert the value of the above cell into the cell currently selected.
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.
F4 Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.

Top 101 + Microsoft Excel shortcut keys - It Clues Top 101 + Microsoft Excel shortcut keys - It Clues Reviewed by itclues on 10:12 Rating: 5

No comments:

Powered by Blogger.