Are you a student or office worker and often use Excel to work? Below, Winrar Download gives you a few tips and tricks to help you work faster and improve work efficiency.
Table of Contents
1. Remove duplicate values in Excel
This happen when a colleague sends you a data file that has duplicate data that you want to delete. Short files can be manually deleted line by line, but files with thousands of lines cannot be deleted like that, for example, duplicate employee ID. So, to make it easier and faster, please follow these steps below:
Step 1: Access Microsoft Excel, open the file that you want to make change on. Ctrl + A, to highlight all datas. Remember, there is no other content outside the table.
Step 2: On the Toolbar, select Data, then select Remove Duplicates.
Step 3: A new window appears, here you select Unselect All -> Select the ID column -> OK
2. Automatically draw cell borders when adding data in Excel
The data table has cell borders, each time you add a row of data you have to reformat the table and add cell borders. Below are tips to help you automatically draw cell borders when adding new rows of data.
Step 1: Access Microsoft Excel, open the file that you want to make change on. Highlight the data table, scroll down to the lines below as shown in the image below.
Step 2: Select Conditional Formating -> New rule… -> Use a formula to determine which cells to format.
Step 3: Creat a conditional statement in the text box.
Select the first row of the data table. Next, press F4 twice to remove the second $ sign.
Select the first cell of the table. Continue pressing F4 twice. And compare it with empty. My conditional statement after creating it (=$A2<>””) After creating the conditional statement, select Format…
After selecting Format…->Border -> Ouline -> OK
That’s it, you won’t have to waste time drawing the borders anymore.
3. Fixed column and row titles in Excel.
Fixed title helps you see the title even when you scroll the page, the title will always be at the top, you can always see what the column name and row name are.
Step 1: Access Microsoft Excel, open the file that you want to make change on. Blacken the columns and rows that need to be fixed.
Step 2: Place the mouse cursor at the diagonal corner
Step 3: Select View -> Freeze Panes -> Unfreeze Panes
Try it and see the results. Very convenient when the Excel data file has thousands of rows and many columns.