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

Categories:Excel Tips

  • 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 […]