Hi friends today i would like to show you that how can you use EXCEL with shortcut keys. Using shortcut is the way to use faster and perfectly. By using the shortcut other people things that he is perfect in his work.
Here is the some shortcut keys.
F2 = Edit the Selected Cell.
F3 = After a name has been created, F3 will paste names.
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.
F5 = Go to a specific cell. For example, C6.
F7 = Spell check selected text or document.
F11 = Create chart from selected data.
Ctrl + Shift + ; = Enter the current time.
Ctrl + Shift + 1 = Format number in comma format.
Ctrl + Shift + 2 = Format number in time format.
Ctrl + Shift + 3 = Format number in date format.
Ctrl + Shift + 4 = Format number in currency format.
Ctrl + Shift + 5 = Format number in percentage format.
Ctrl + Shift + 6 = Format number in scientific format.
Ctrl + Shift + = = Insert a new column or row.
Ctrl + Home = Move to cell A1.
Ctrl + Arrow key = Move to next section of text.
Ctrl + Space = Select entire column.
Ctrl + - = Delete the selected column or row.
Ctrl + ~ = Switch between showing Excel formulas or their values in
cells.
Ctrl + ; = Enter the current date.
Ctrl + ' = Insert the value of the above cell into the cell currently selected.
Shift + Space = Select entire row.
Shift + F3 = Open the Excel formula window.
Shift + F5 = Bring up search box.
Alt + Shift F1 = Insert New 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.
Alt + = = Create a formula to sum all of the above cells.
No comments:
Post a Comment