标签：Excel
-
How to Merge Duplicate Cells and Calculate the Summation in Excel
In actual statistics, a person or an item could appear multiple times in the list with different values followed. We can’t simply delete any of them. Instead, we need to combine these cells and sum their values. So how can we achieve it? Look at the table below. It’s apparently that there’re 2 person show […]
-
How to Insert a Superscript in Microsoft Excel
Sometimes you can’t avoid the units with superscripts in Excel sheet such as m2 and m3. Inserting superscripts in Excel is not as easy as in Word. Let’s see how to achieve it. Now I want to input m2 in Excel, so I type m2 in the cell first. Select the content you want convert […]
-
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 […]
-
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 […]
