Categories：Excel Tips
-
How To Move Excel Columns? (Super Easy Tutorial)
What? Someone is stilling cut and paste columns in Excel to change the columns’ place! Come on, just press and hold the Shift key on your keyboard can handle this. Here are three columns. Now, let’s move Excel column C into the first column position. Select the area of column C and put your cursor […]
-
How To Auto Fill Color in Excel Based on Key Words?
We usually use Ctrl and F to quickly find the content we need in Excel. There is a function that can also help us to find something by keywords and even filling color to tell from other cells. So, how to auto-fill color in Excel? Let’s check this out. Here is a full name list. […]
-
How to Copy Only Visible Cells in Excel
We may filter or hide columns/cells rows to classify or analyze data easily. But copy and paste can not work normally in this situation. For example, how to copy only visible cells in Excel? Let’s check this out. Default copy and paste with hidden cells in Excel. Here is a score table for classes […]
-
How to sum by color in Excel?
Supposing we have a vegetable sales table as below, and we need to count or sum the colored cells. Is there any fast way to deal with this? So how to sum by color in Excel? Let’s check this out! Method 1: Click on any cell and press Ctrl and F to open the Find […]
-
How to Sum Every Other Column in Excel?
In our last tutorial, we learned the way of how to sum every other row in Excel. Let’s continue this in the second part, knowing how to sum every other column in Excel. Here is a random number table. Let’s get the sum of the odd columns as the screenshot below first. Type this =SUMPRODUCT((MOD(COLUMN(A1:G10),2)=1)*A1:G10) […]
-
How to Sum Every Other Row in Excel?
As we all know, the sum function can help us easily get the sum of a row or column, or even an area. But on special occasions, we need to sum up every other row in Excel. So, this is today’s point, how to sum every other row in Excel? Let’s take an example. Here […]
-
How to Calculate Age from Date of Birth in Excel?
In our today’s tutorial, we’ll learn how to get age from birthday in Excel. We of course make a formula to compute the ages quickly. Let’s check this out. Here is a worksheet that contains several dates of birth. Type [=DATEDIF(B2,TODAY(),”y”)] in cell C2 and press Enter key. Use the fill handle to get all […]
-
How to Send Mass Email from Excel?
Are you looking for one software to help you send emails in bulk? Someone may say that just need to save these email addresses into a group and then mail them. Come on, every email platform can do this, but the prerequisite is that you allow all the content of emails is the same. Suppose […]
-
How to Create a Bubble Chart in Excel?
There are many kinds of charts. Different charts present different effects. The bubble chart can visually show the relationship between the three variables. In this article, I will introduce how to create a bubble chart in Excel. Take this table as an example. Click any blank cell and click insert, then Scatter or Bubble […]
-
How to Generate Random Numbers in Excel
Have you got the usage of the CHOOSE function in Excel? We learned this in our last post. We will continue to use this function today. Suppose we need to get a list of random serial numbers in Excel. What should you do? Let’s check this out. Using the RAND function to get random numbers […]
