MS Excel shortcuts

 

MS Excel  

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; strikethrough
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.
Ctrl+Home		Goes to first sell off the sheet.
Ctrl+End		Goes to the last cell of the sheet.
Ctrl+Tab		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.
Alt+Tab		Goes to another opened window.
Alt+Spacebar		Selecting the top menu.
Alt+Backspace		Backward
Alt+Enter		**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