Microsoft Excel Tips and Tricks 2020 You Need to Know

1. Remove Duplicates

Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates. Click Okay.

This is a great tip to use when you need to extract the unique values of data from a spreadsheet of many rows of data. For example, you have an Excel file with customer information data and you want to see which states you have reached. With just 3 clicks in Excel, you can remove the duplicate values from the ‘State’ column and quickly see all the states that you have customers. Ta-da!

2. Spell Check

Have you ever found yourself frustrated at the lack of auto-spell check within Excel? Well turns out it does exist! Press F7 and Excel will scan your spreadsheet for any spelling errors. This is a life-saver for those employees that are required to deliver reports to managers in an Excel format.

3. Freeze Top Row

On the View tab > Window > Freeze Top Row.

Do you find yourself working with large sets of data within Excel? It is easy to forget the name of the column you are looking at. This will keep the header row visible while you scroll to another area of the worksheet.

4. Wrap Text

On the Home tab, in the Alignment group, click Wrap Text.

Excel can wrap text so it appears on multiple lines in a single cell. This makes it much easier to read and format a report that contains substantial amounts of text or information in a cell.

5. Filter

Select Data > Filter. Select the column header arrowFilter arrow  to start filtering!

An Excel essential is filtering columns of data to quickly and easily drill down your data to see insights. How many customers do we have in California? How many sales did we have in May of last year? Or even a combination of filters that could tell us how many sales did we have in May of last year from California. The options are endless when it comes to filters!

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

Add a Comment

Your email address will not be published. Required fields are marked *