Microsoft Excel tutorial, Excel tips, basic Excel formulas, Excel functions, Excel tricks

Categories:Excel Tips

  • How to Delete the Duplicate Lines in Excel

    Date:2019-7-9 Author:Cordelia

    When you’re dealing with a bunch of data in Excel, it can be a headache to find and remove all the unwanted duplicate lines. How to eliminate them in a quick and simple way? Excel itself has the function called Remove Duplicates. Let’s see how to make use of it. 1. Select the range of […]

  • How to Sort Data in Excel by Multiple Conditions

    Date:2019-7-9 Author:Cordelia

    In my previous post I’ve introduced the method of sorting data in Excel by single condition. But in actual operation we usually need to sort the data according to more than one conditions. How can we do that? For example, there are some students with the same score in the grade table such as Ray […]

  • How to Sort Data in Excel by Single Condition

    Date:2019-7-9 Author:Cordelia

    The content you input in Excel sheets manually may be unordered and messy, which is not conductive to view or comparison. It’s necessary to sort the data especially when you are editing a ranking table. Sorting refers to rearranging one or several fields in the table according to a specific rule. Let’s see how to […]

  • How to Batch Set the Row Height and Column Width Precisely in Excel

    Date:2019-7-9 Author:Cordelia

    It’s common to adjust the row height and column width in Excel while editing a table, especially when the content is too much to fit in the cell’s size. The most direct way for this situation is moving your mouse to drag the rows or columns, which you should’ve used for many times before. But […]

  • How to Start a New Line in Excel

    Date:2019-7-2 Author:Cordelia

    When you input too much content in a single cell, the text will slop over the borders and affect the layout of your whole table in Excel. The best way to solve this problem is inserting a line break and starting a new line in cell. There’re 2 common methods to achieve it. 1. Manually […]