归档： 2019 July 16
-
How to Insert an Excel File in Word Document
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
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
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
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
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 […]
