23:41
Babji Shaik
Excel Tips And Tricks
Hi friends! In this post, you are going to know Top Excel Tips And Tricks. Some of you may familiar with these Excel Tricks but you will find some very useful tricks in excel.
 |
| Excel Tips And Tricks |
Though you’re well known with Microsoft Excel, you might be surprised by the number and variety of Excel Tricks which I have given. You can use these in your work to make things more convenient.
Tricks in Excel
Tricks in Excel
Ctrl + A: will select all of the data
Ctrl + C: will copy the selected data (or object)
Ctrl+F: Search in a spreadsheet, or use Find and Replace
Ctrl+N: Create a new workbook
Ctrl + V: will paste the copied data (or object)
Ctrl+O: Open an existing workbook
Ctrl+Z: Undo an action
Ctrl+S: Save a workbook
Ctrl+W: Close a workbook
Alt+Q: Go to the “Tell me what you want to do” box
Ctrl+Y: Redo an action
Ctrl + End: will take you to the last cell of your data
Ctrl + Home: will take you to the first cell of your data
Ctrl + Up Arrow: will take you to the first cell of your active column
Ctrl + Down Arrow: will take you to the last cell of your active column
Ctrl + Space: will select column(s) of your active cell(s)
Ctrl + minus sign: will give you Delete options
Ctrl+Tab: Switch between open workbooks
Ctrl+F4: Close Excel
Shift+F9: Calculate active worksheets
Shift+F11: Insert a new worksheet
Shift + Space: will select row(s) of your active cell(s)v
Shift + Space: will select row(s) of your active cell(s)
Shift+F3: Insert a function
Ctrl+F2: Switch to Print Preview
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)
F1: Open the Help pane
F7: Check spelling
F9: Calculate all worksheets in all open workbooks
F12: Open the Save As dialog box
 |
| Excel Tips And Tricks |
Alt+F8: Create, run, edit, or delete a macro
Alt+F11: Open the Microsoft Visual Basic For Applications Editor
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
Alt+F1: Create an embedded bar chart based on select data (same sheet)
Alt or F10: Turn key tips on or off
Finally, The more you use Excel Tricks, the easier they are to remember. Hopefully, you have found a few new ones, you can use Tips And Tricks to make your life in Excel a little better.
0 Comments:
Post a Comment