Excel Shortcut Keys - Latest Super Tricks

Excel Shortcut Key

Read Here New Excel Tricks Free | Get computer Tricks with us

Keys	Keys Descriptions
F1	Open “Microsoft Office Excel Help“
F2	Edit an selected Excel cell.
F3	Displays the “Paste” dialog box.
F4	Repeats the last action
F5	Opens “Go To” dialog box.
F6	Switches between worksheet and menu / Ribbon.
F7	Check Spelling of selected cell.
F8	Switches Extend mode on/off.
F9	Calculates all worksheets in all open workbooks.
F10	Highlights shortcut keys of Menu and Ribbon items.
F11	Creates chart of selected cells.
F12	Opens “Save As” dialog box.
CTRL + 1	Opens “Format Cells” dialog box.
CTRL + 2	Makes bold selected cell text .
CTRL + 3	Makes italic selected cell text .
CTRL + 4	Makes underline selected cell text.
CTRL + 5	Makes selected cell text strike through.
CTRL + 6	Displays / hides objects.
CTRL + 8	Displays / hides outline symbols.
CTRL + 9	Hides selected rows.
CTRL + 0	Hides selected columns.
CTRL + A	Select whole worksheet.
CTRL + B	Makes selected cell text bold.
CTRL + C	Copy selected all  data.
CTRL + D	Fill Down or paste topmost cell to all selected cells below it.
CTRL + F	Open “Find and Replace” dialog box.
CTRL + G	Open “Go To” dialog box.
CTRL + H	Open “Find and Replace” dialog box with “Replace” .
CTRL + I	Makes italic all selected cell text.
CTRL + K	Open “Insert Hyperlink” dialog box.
CTRL + N	Open new workbook
CTRL + O	Open “Open” dialog box.
CTRL + P	Open “Print“dialog box.
CTRL + R	“Fill Right” command to paste leftmost cell to all selected cells in the right side.
CTRL + S	Open “Save As” dialog box.
CTRL + T	Open “Create Table” dialog box.
CTRL + U	Make underline selected cell text.
CTRL + V	Paste data on selected area
CTRL + W	Close current sheet.
CTRL + X	Cut selected cell text
CTRL + Y	Redo last action.
CTRL + Z	Undo last action.
ESC	Escapes dialog box, message box and discards text while writing in cell.
TAB	selects right side cell.
SHIFT + TAB	selects left side cell.
CTRL + TAB	Switches to next tab in dialog box.
CTRL + SHIFT + TAB	Switches to previous tab in dialog box.
ENTER	Moves to one cell downwards.
ALT + ENTER	Merge within a cell.
CTRL + ENTER	Paste copied cell to all selected cells.
SHIFT + ENTER	Moves to one cell upwards.
SPACEBAR	Checks/Unchecks the checkbox, radio buttons and works like ENTER key in dialog box.
CTRL + SPACEBAR	Selects an entire column in a worksheet.
SHIFT + SPACEBAR	Selects an entire row in a worksheet.
CTRL + SHIFT + SPACEBAR	once will select current data range, second time it will select whole sheet cells and third time it will select whole worksheet
ALT +SPACEBAR	Displays the Control menu for the Microsoft Office Excel window.
DELETE	Remove the data from selected cell (Not formatting).
HOME	Move to left-most cell in the row.
CTRL + HOME	Movs to the top-left cell of a worksheet.
CTRL + SHIFT + HOME	Select cells to the beginning of the data range from current cell.
END	Move to the cell in the lower-right corner of the window
CTRL + END	Move to the last cell in the lower-right corner of window.
CTRL + SHIFT END	Select cells to the end of the data range from current cell.
PAGE UP	Move the current view of worksheet to one screen up.
CTRL + PAGE UP	Move to the previous sheet in workbook.
ALT + PAGE UP	Move the current view of worksheet to one screen to the left.
CTRL + SHIFT + PAGE UP	Move to the previous sheet in workbook.
PAGE DOWN	Move the current view of worksheet to one screen down.
CTRL + PAGE DOWN	Move to the next sheet in workbook.
ALT + PAGE DOWN	Move the current view of worksheet to one screen to the right.
CTRL + SHIFT + PAGE DOW	Move to the next sheet in workbook.
ARROW	Move to one cell left / right / up / down.
CTRL + ARROW	Move to extreme left / right / up / down in a selected data range or blank sheet.
SHIFT + ARROW	Select / deselect one cell in the left / right / up / down from current cell.
CTRL + SHIFT + ARROW	Select / deselect current range of data or blank sheet in the left / right / up / down from current cell.
ALT + DOWN ARROW	Show a list of data in cells above to current cell as a drop down.