Ms excel is the part of Microsoft Office,Ms Excel is used
to make or create a spreadsheet Document they are commonly used in Offices
, Schools, University’s and there like Business work,
If you want to use Ms. Excel then you should follow these Shortcuts After that, you will be able to edit or make a new Excel sheet
Shortcuts
All shortcuts that are commonly used in MS Excel You Read them and Grow your skill
Shortcuts | Description | |
Tab | Move to next cell, to the right of the currently selected cell | |
Ctrl+A | To select all. | |
Ctrl+B | Bold. | |
Ctrl+C | To Copy. | |
Ctr+F | Search/Find (if you need to find any word/words in the file) | |
Ctrl+G | Go to a certain area(certain area) | |
Ctrl+H | Find and replace (find any word/words in a file and replace it) | |
Ctrl+I | Puts ‘italics’ style on the highlighted section. (like as italics ) | |
Ctrl+K | Hyperlink(add a link in a word such as Click here. ) | |
Ctrl+L | Create a new Table dialog box cells | |
Ctrl+N | Create a new sheet. | |
Ctrl+O | Open a sheet. | |
Ctrl+P | To Print the sheet. | |
Ctrl+R | Fill multiple cells. (first, fill one cell and hold the right courser at end of cell and moves to any other the cell in the only Row) | |
Ctrl+S | Save. (save the sheet in given location) | |
Ctrl+U | Underlines all cells in the selected section(like as Welcome) | |
Ctrl+V | Paste here. | |
Ctrl+W | Close. | |
Ctrl+X | Cut the mentioned part. | |
Ctrl+Y | Redo repeat the previous work. | |
Ctrl+Z | ‘Undo’ remove the mention work. | |
Ctrl+1 | Correction of the mention cells | |
Ctrl+2 | The selected section will Bold. | |
Ctrl+3 | show italics style | |
Ctrl+4 | Shows Underlined style. | |
Ctrl+5 | shows strikethrough style like as; | |
Ctrl+6 | shows objects. (Hides or unhide) | |
Ctrl+7 | shows toolbar(hide or show) | |
Ctrl+8 | the outline symbols “Toggles” | |
Ctrl+9 | Show the hides rows. | |
Ctrl+0 | Show the hides columns. | |
Ctrl+SHIFT+: | The current time will be entered. | |
Ctrl+; | The current date will be entered. | |
Ctrl+' | Shows formula copied. | |
Ctrl+Shift+" | Copy values in the cell. | |
Ctrl+- | Column or row will be deleted. | |
Ctrl+Shift+= | Insert. | |
Ctrl+Shift+~ | Mentioned the values or formulas. | |
Ctrl+Shift+@ | Time formatting. | |
Ctrl+Shift+! | Comma formatting. | |
Ctrl+Shift+$ | Currency formatting applies. | |
Ctrl+Shift+# | Date formatting applies. | |
Ctrl+Shift+% | Percentage formatting applies. | |
Ctrl+Shift+^ | Expand formatting. | |
Ctrl+Shift+* | Mentions current region. | |
Ctrl+Shift+& | The border will be placed around selected cells. | |
Ctrl+Shift+_ | Take out a border. | |
Ctrl++ | Put a border. | |
Ctrl+- | Remove. | |
Ctrl+Shift+( | Striking. | |
Ctrl+[ | Pressing to select all cells that are connected with the mentioned formula. | |
.Ctrl+] | Selects. | |
Ctrl+Shift+{ | Selects The cell directly to highlight input formula. | |
Ctrl+Shift+} | Mention all the cells (which contain formulas ) in active form. | |
Ctrl+Shift+| (pipe) | You try please, hmmm | |
Ctrl+Spacebar | Select the whole column. | |
Ctrl+Shift+ Spacebar | Select all the worksheet cells. | |
Goes to first sell off the sheet. | ||
Goes to the last cell of the sheet. | ||
Goes to another opened tab of the excel file. | ||
Ctrl+Shift+Tab | Last Activates. | |
Ctrl+Shift+A | Name into a formula. | |
Ctrl+Shift+F | Foants_menu_popup. | |
Ctrl+Shift+O | Mention (the cells that have) comments. | |
Ctrl+Shift+P | Foants+other_menu_popup. | |
Shift+Insert | Paste here. | |
Shift+Page Up Shift+Page Down | Indicates all the upper column cells(from selected cell). | |
Shift+Home | Indicate all the right side cells (right to left). | |
Shift+End | Active the -End Mode. | |
Shift+Up Arrow | Selecting cells to upwards direction. | |
Shift+Down Arrow | Selecting cells to downwards direction. | |
Shift+Left Arrow | Choosing cells in row one by one right to left. | |
Shift +Right Arrow | Choosing cells in row one by one left to right. | |
Goes to another opened window. | ||
Selecting the top menu. | ||
Alt+Backspace | Backward | |
**Missing** | ||
Alt+= | Create a sum formula all for above. | |
Alt+' | Formatting on a dialog box. | |
F1 | The help menu. | |
F2 | Edit the all highlighted cell. | |
F3 | F3 will paste names after creating a name. | |
F4 | Repeat the last action. | |
F5 | Goes to a selected cell. For For example,click to type C6 it goes to the C column and its 6th row. | |
F6 | Move to next pane(Appears the menu bar in shortcuts) | |
F7 | Check the spelling of selected text or document. | |
F8 | Extended selection (Enters Extend Mode). | |
F9 | Recalculation of every workbook. | |
F10 | Appears the menu bar in shortcuts. | |
F11 | Create a chart from selected data in the opened sheet. | |
F12 | Save the file as an option . | |
Shift+F1 | Open the "???" window. | |
Shift+F2 | Open a sell comment (Allows the user to edit a cell comment). | |
Shift+F3 | Excel formula window open. | |
Shift+F5 | Appears as a search box. | |
Shift+F6 | Move to the previous pane. | |
Shift+F8 | Add to selection. | |
Shift+F9 | Performs calculate function on the active sheet. | |
Ctrl+F3 | Excel Name Manager Open. | |
Ctrl+F4 | the current window closed. | |
Ctrl+F5 | window size Restored | |
Ctrl+F6 | Go to Next sheet. | |
Ctrl+Shift+F6 | Go to Previous sheet. | |
Ctrl+F7 | Window moved | |
Ctrl+F8 | Window resized | |
Ctrl+F9 | Minimize. | |
Ctrl+F10 | (window)Maximized | |
Ctrl+F11 | New macro sheet. | |
Ctrl+F12 | File open. | |
Ctrl+Shift+F3 | using those of either row or column labels to Creates names | |
Ctrl+Shift+F6 | Move to the previous worksheet.( the previous worksheet window) | |
Ctrl+Shift+F12 | printed. | |
Alt+F1 | A new chart | |
Alt+F2 | Save As file. | |
Alt+F4 | Exit. | |
Alt+F8 | macro dialog box. | |
Alt+F11 | Visual Basic editor. | |
Alt+Shift+F1 | Create a new sheet. | |
Alt+Shift+F2 | Save as.
| |
| ||
Ctrl+ENTER
2 Comments
thks dude for the tips, it help me when im using excel hehehe
ReplyDeletethks man for ur tips ^_^
ReplyDeleteThanks for your feedback we will reply Fast.