Most Useful Microsoft Excel Shortcut Keys

1 Create a formula to sum all of the above cells - Alt+F11 2 Current Date - Ctrl + ; 3 Current Time - Ctrl + Shift + ; 4 Select Entire row - Shift + Space 5 Select Entire Column - Ctrl + Space 6 Hide Rows - Ctrl + 9 7 Hide Column - Ctrl + 0 8 Delete a Column or Row - Ctrl + - 9 New Line In Cell - Alt+Enter 10 Show hide Formula - 11 Save As active file - F12 12 Create Charte From Select Date - F11 13 Insert New Worksheet - Shift + F11 14 Move Forward Between worksheets in the same document. Ctrl + Pg Down 15 Move back between worksheets in the same documnet. - Ctrl + Pg Down 16 Format Number in comma format - Ctrl + Shift + 1 17 Format number in date format - Ctrl _ Shift +3 18 Format number in currency format ($) - Ctrl + Shift +4 19 Format number in percentage format - Ctrl +Shift + 5 20 Move to cell A1 - Ctrl + Home 21 Switch between showing Excel formula or their values in cells - Ctrl + ` Can be kept handy in OneNote or Google Keep :)

What a great shortcut key۔۔۔۔thanks sir

Superb video. I learn many new things from you.

Maa-Shaa-Allah, thanks Dear. Very informative video.

Ctrl+N: Create a new workbook Ctrl+O: Open an existing workbook Ctrl+S: Save a workbook F12: Open the Save As dialog box Ctrl+W: Close a workbook Ctrl+F4: Close Excel F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell. Shift+F11: Insert a new worksheet Ctrl+Z: Undo an action Ctrl+Y: Redo an action Ctrl+F2: Switch to Print Preview F1: Open the Help pane Alt+Q: Go to the “Tell me what you want to do” box F7: Check spelling F9: Calculate all worksheets in all open workbooks Shift+F9: Calculate active worksheets Alt or F10: Turn key tips on or off Ctrl+F1: Show or hide the ribbon Ctrl+Shift+U: Expand or collapse the formula bar Ctrl+F9: Minimize the workbook window F11: Create a bar chart based on selected data (on a separate sheet) Alt+F1: Create an embedded bar chart based on select data (same sheet) Ctrl+F: Search in a spreadsheet, or use Find and Replace Alt+F: Open the File tab menu Alt+H: Go to the Home tab Alt+N: Open the Insert tab Alt+P: Go to the Page Layout tab Alt+M: Go to the Formulas tab Alt+A: Go to the Data tab Alt+R: Go to the Review tab Alt+W: Go to the View tab Alt+X: Go to the Add-ins tab Alt+Y: Go to the Help tab Ctrl+Tab: Switch between open workbooks Shift+F3: Insert a function Alt+F8: Create, run, edit, or delete a macro Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Thank you so much for useful information you save our time..

Ok super very useful shortcut..pls update many vedios

Thank you so much. Since I used to skip computer lessons way back college days, I just learned the shortcuts thru here.

Nice short keys....i mean without mouse very useful for keys

very nice it's very useful

Very good

that su bo ich, rat ne va quy nhung nguoi san sang chua se kien thuc ban than cho nguoi khac cam on ban rat nhieu

Really handy video. All the shortcuts actually worked and the video was easy to follow. TFS!

Good information videos sir

Wounderfull work amazing sir. Stay connected

And goo presentation

Very helpful information. Thanks.

Concise and Useful

Best video naer