Archiver: 2019 July 17

  • How to Freeze Specific Cells in Microsoft Excel

    Date:2019-7-17 Author:Cordelia

    A large table with tons of data usually can’t be fully displayed in a single page. You must scroll down or scroll to the right for a more complete viewing. In order to correspond these data with the title or other key content intuitively, you can freeze some specified cells in the table. In this […]

  • How to Remove the Dotted Borders in Excel

    Date:2019-7-17 Author:Cordelia

    Have you ever seen one or more dotted borders in your Excel worksheet? It appears all of a sudden and can’t be deleted by normal means, which could be quite annoying. This kind of dotted line is actually caused by the switching of workbooks views. You can see this feature in View tab or the […]

  • How to Quick Hide or Unhide Rows/Columns in Excel

    Date:2019-7-17 Author:Cordelia

    While editing a table in Excel, there may be some less important content you can’t delete but also don’t need to keep an eye on all the time. Hiding these rows or columns could make the table looks more compact without substantial impact for the data, and that’s exactly what I want to share in […]

  • How to Copy Excel Formulas to Multiple Cells or Entire Column

    Date:2019-7-17 Author:Cordelia

    If you have tons of data to deal with in a spreadsheet, it’s much more convenient to use Excel functions instead of manual calculations. But inputting formulas in each cell can also take a lot of time. Is there a way to enter it just once and apply the formula to multiple cells within seconds? […]

  • 2 Ways to Add Auto Reminders on Due Date in Excel

    Date:2019-7-17 Author:Cordelia

    Working with the data in Excel spreadsheets often requires a reminder of the due date, such as the due date of receivable. In this post, I’ll introduce 2 methods to add a due date reminder in your Excel sheet. Hope it can be helpful to your work. 1. Functions See the example below. I create […]