Latest Excel Tips and Tricks 2020 by Excel Sir

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.