归档: Cordelia

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

    时间:2019-7-17 作者: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

    时间:2019-7-17 作者: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 […]

  • How to Insert an Excel File in Word Document

    时间:2019-7-16 作者:Cordelia

    Word is one of the most commonly used office software in work and study. In order to make a Word document more convincing, we could insert other kinds of files in it for reference. For example, if we insert an Excel file in Word document, we can then refer to the original data while reviewing […]

  • How to Lock Specific Cells in Excel to Protect the Data

    时间:2019-7-16 作者:Cordelia

    When we are editing a table with Excel, some of the data in it may be so important that can’t be modified by others freely or by ourselves incautiously. If we can lock one or several cells in the table only, we can then focus more on processing the data without extra worries. How to […]

  • How to Transpose Rows and Columns in Excel

    时间:2019-7-16 作者:Cordelia

    If you are not satisfied with the current state of your table in Excel, and consider the content in rows should be in columns or vice versa, you can transpose them using the feature of Paste Special. Let’s see an example. I have this table below and want to switch the rows and columns. So […]

  • How to Combine the Content from 2 Columns in Excel

    时间:2019-7-16 作者:Cordelia

    If there are two columns in your table containing different kinds of information, and you need to merge them for some reasons, could you combine the texts from these 2 columns using functions of Excel instead of copy&paste one by one? Let’s see the table below. Now I want to combine column A and column […]

  • How to Add a Diagonal Line to the Cell in Excel

    时间:2019-7-16 作者:Cordelia

    While making a table in Excel, you may often have the need to insert a diagonal line in the cell of header and input some texts in it, such as names, regions, months, etc. This table below is an example. I want to draw a slash in the cell A1, and input “Name“, “Decimals” separately […]

  • How to Calculate Percentages Automatically in Excel

    时间:2019-7-12 作者:Cordelia

    It’s very frequent at work to make a sheet involving percentages of different departments in the whole company. Calculating percentages with a calculator surely won’t take a lot of your time. But if there’re piles of data to deal with in a short time, can you accomplish it efficiently without any mistake? If not, it’s […]

  • How to Set Line Spacing in Word

    时间:2019-7-12 作者:Cordelia

    While typesetting a document in Word, it’s a necessary operation to set the line spacing of text. Many of you may already know it very well. But for those people who’s still not familiar with the steps, I’ll make a simple guide here. Select the text you want to typeset. If you want to modify […]

  • How to Input Fractions in Word 2016

    时间:2019-7-12 作者:Cordelia

    If you are editing a document involving math, you may need to input some mathematical symbols including fractions. In this post, I’d like to introduce the way to insert a fraction in Word 2016. Click Object in Insert tab. There’re two options in the drop-down list, choose Object… When the Object window pops out, find […]