Categories：Excel Tips
-
How to Change Excel Sheet from Right to Left?
The Excel sheet direction is from left to right by default. But you can change the Excel sheet from right to left if required. There is an easy way can do this in seconds. Here is a fruit price table. Now we go to the File tab from the ribbon and click on the options […]
-
How to Automatically Replace Text in Microsoft Excel
If you are always typing your company name repeatedly, or a very long name in Excel. You can actually use a very quick way to avoid typing repeatedly. Go To File And Choose Options. Select Proofing in the list and click on AutoCorrect Options. For example, if we want to get ‘My Office Tricks’ quickly, we […]
-
How to Print Large Excel Sheets?
We can print a long Excel sheet into several pages, but how to print a wide Excel sheet on one page? Here is a fruit price table. Now we select the table area and press Ctrl and P to print it. There is no doubt that the table is too wide to print completely. It […]
-
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 […]
