归档： 2019 July 17
-
How to Freeze Specific Cells in Microsoft Excel
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
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 Copy Excel Formulas to Multiple Cells or Entire Column
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
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 […]
