Learn Latest Excel Tips and Tricks 2020 by Excel Sir.
Basic Tips for Excel
If you're simply starting out with Excel then those hints
can save you lots of time and permit you to get higher quickly in ordinary
duties.
Here are few tips that will help you to do your work
quickly.
Select All:- Ctrl + A
Current Date and Time:- We can easily add current Date and
Time in any cell by just using this simple shortcut in Excel
Ctrl + ; :- To Date
Ctrl + Shift + ; :- To add Current Time
Ctrl+N:- Create a new workbook in Excel
Ctrl+O:- Open an existing workbook in Excel
Ctrl+S:- Save a workbook in Excel
F12:- Open the Save As dialog box in Excel
Ctrl+W:- Close a workbook in Excel
Ctrl+F4:- Close Excel
F1:- Open the Help pane in Excel
F4:- Repeat the last command or action. For instance, if the
last thing you typed in a cell is “Book,” 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 in Excel
Ctrl+Z:- Undo an action in Excel
Ctrl+Y:- Redo an action in Excel
Ctrl+F2:- Switch to Print Preview in Excel
Alt+Q:- Go to the “Tell me what you want to do” box in Excel
F7:- Check spelling in Excel
F9:- Calculate all worksheets in all open workbooks in Excel
Shift+F9:- Calculate active worksheets in Excel
Alt or F10:- Turn key tips on or off in Excel
Ctrl+F1:- Show or hide the ribbon in Excel
Ctrl+Shift+U:- Expand or collapse the formula bar in Excel
Ctrl+F9:- Minimize the workbook window in Excel
F11:- Create a bar chart based on selected data in Excel
Alt+F1:- Create an embedded bar chart based on select data
in Excel
Ctrl+F:- Search in a spreadsheet, or use Find and Replace in
Excel
Alt+F:- Open the File tab menu in Excel
Alt+H:- Go to the Home tab in Excel
Alt+N:- Open the Insert tab in Excel
Alt+P:- Go to the Page Layout tab in Excel
Alt+M:- Go to the Formulas tab in Excel
Alt+A:- Go to the Data tab in Excel
Alt+R:- Go to the Review tab in Excel
Alt+W:- Go to the View tab in Excel
Alt+X:- Go to the Add-ins tab in Excel
Alt+Y:- Go to the Help tab in Excel
Ctrl+Tab:- Switch between open workbooks in Excel
Shift+F3:- Insert a function in Excel
Alt+F8:- Create, run, edit, or delete a macro in Excel
Alt+F11:- Open the Microsoft Visual Basic For Applications
Editor in Excel
Left/Right Arrow:- Move one cell to the left or right in
Excel
Ctrl+Left/Right Arrow:- Move to the farthest cell left or
right in the row in Excel
Up/Down Arrow:- Move one cell up or down in Excel
Ctrl+Up/Down Arrow:- Move to the top or bottom cell in the
column in Excel
Tab:- Go to the next cell in Excel
Shift+Tab:- Go to the previous cell in Excel
Ctrl+End:- Go to the most bottom right used cell in Excel
F5:- Go to any cell by pressing F5 and typing the cell
coordinate in Excel
Home:- Go to the leftmost cell in the current row in Excel
Ctrl+Home:- Move to the beginning of a worksheet in Excel
Page Up/Down:- Move one screen up or down in a worksheet in
Excel
Alt+Page Up/Down:- Move one screen to the right or left in a
worksheet in Excel
Ctrl+Page Up/Down:- Move to the previous or next worksheet
in Excel
Thank you for visiting this page.
