Skip to main content

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.
Labels:

Comments

Post a Comment

Popular posts from this blog

How to Create A Free Website And Earn Money Online - LST

How to Create A Free Website And Earn Money Online Dear Friends Do you want your own free Website or Blog ? But you don't know how to create it for free. Then you are at right place. Now I'm in this post " How to Create A Free Website And Earn Money Online " will tells you that how you can create a free website or blog. Now i will tell you that it is very simple as like to create a Facebook or Gmail id. In today modern world all work is done online. If you are a student then you will understand better. For example you apply for admission online and also apply for scholarship. For this admission providers will have a website.  So that in modern time we stay always with new technologies and Internet. So we must have at least one free website or blog. You Surprised to hear that not only you can share your ideas to online but you can also earn money Online from this free website or blog. It is Surprised that in our Country many people making money with...
2 comments
Read more

Miss You Thoughts Wallpaper

Post a Comment
Read more

Top Ten Facebook Tips and Tricks

Hi Friends today i telling you best useful Facebook Tips and Tricks. As you know that Facebook is very popular social networking site, so today I'm sharing some useful tips and tricks with you..  As you know that we use Facebook for chatting, making new friends, making a community like a page, a group to linked all friends together to share there thoughts with in a page or group. So many people's are addicted to Facebook but many of them don't use Facebook Tricks because they don't know. But I am going to share this knowledge with you, if you are also Facebook addicted like me then these FB tips and tricks are may be very useful for you.  Facebook Tips and Tricks   1) Blank Status Trick You can't post blank status on Facebook, at least one letter, comma, or a symbol is compulsory to make a post on FB. But here is Tricks by which you can post blank status on FB.  For this trick type @[0:0: ] in Facebook post field and submit, in place of zero you c...
3 comments
Read more