标签:format cells

  • How to Customize and Unify the Date Format in Excel Quickly

    时间:2019-9-23 作者:Cordelia

    It’s quite troublesome to enter dates into Excel Spreadsheet with a canonical format manually. But if you don’t unify the format, it will affect the operation with formulas in the sheet. Therefore, I’d like to introduce 2 ways to unify the entered data and display them as the customized format. Method 1: Using Format Cells to […]

  • How to Display Numbers as Asterisks in Excel Cells

    时间:2019-9-19 作者:Cordelia

    When you log in some software, the password you entered will be displayed as asterisk to protect your privacy. In Excel, you can also achieve this effect to prevent some important data from being peeked by others. So how to display number as asterisks in Excel cells? It’s a very simple trick. You just need […]

  • How to Batch Add Units to Cells in Excel Spreadsheet

    时间:2019-8-29 作者:Cordelia

    Adding units to one or several cells in Excel might not be difficult and many people are likely to type them after the values directly. However, this approach is not just time-consuming, but can also affect the result for calculation and invalidate some formulas. So, how to add units to multiple cells in Excel exactly? […]