标签：Excel 2016
-
How to Sort Data by Font Color in Microsoft Excel
When editing a worksheet, sometimes you might change the color of the font to make the it more readable. And in some cases, like analyzing monthly sales data, you need to sort data by font color in Excel, which could help to understand your data better, quickly find what you want and make more effective […]
-
3 Methods to Wrap Text in Microsoft Excel
Microsoft Excel doesn’t wrap text by default, no matter how much text you enter in one cell. This could lead to the content of cells beside being covered, and finally affect the layout of the entire Excel spreadsheet. To avoid this , you can try these methods to wrap text in Microsoft Excel manually or […]
-
How to Make Excel Files Compatible with Earlier Versions
If you work with a recent version of Excel like Excel 2016, Excel 2019, the workbook you created may not be displayed correctly in Excel 2003 or Excel 2007. Thus when you send your Excel files to your colleague or friends, there’s a chance they can’t open them normally. In this case, you’d better make […]
-
How to Create an Inverted Histogram in Microsoft Excel
We have shared the method to make a histogram in Excel in previous post, but sometimes you might need to personalize it for special display purpose. Just follow these steps and let’s see how to create an inverted histogram in Microsoft Excel. 1. You got an original histogram in Excel worksheet, and here I take […]
-
How to Check Correctness of Words in Microsoft Excel
Hate to do error checking? Too many words to check? Is there a method to check correctness of words in a quick way? Here’s a simple guide for you to built a perfect worksheet in Microsoft Excel without any mistake. Below is a sample of worksheet in Excel, and there are spelling mistakes in every […]
-
How to Merge Multiple Cells in Microsoft Excel
While making a form in Excel, a header which takes up the width of several cells is often needed. If we have no space to add a new one, the only way may be merging existing cells. Let’s see how to merge multiple cells in Microsoft Excel. 1. Select all cells you want to merge. […]
-
2 Tips of How to Switch Between Multiple Worksheets Quickly in Microsoft Excel
While dealing with many worksheets at the same time, you will certainly need to switch between them. If you know how to switch between multiple worksheets quickly, it could definitely save a lot of time and avoid possible mistakes. Here I’ d like to share two tips of it. Tip 1. Switch Windows in View […]
-
How to Move a Chart in Microsoft Excel
I’ve shared the tip of how to create a histogram in previous post, but you might have a situation that other sheet need the same chart. When there is too much data, reworking the chart can be a waste of time. Is there a solution? Here I’d like to give a simple guide of how […]
-
How to Insert a Radar Chart in Microsoft Excel
We’ve already shared the tip of how to insert line chart, pie chart and histogram in Excel, but sometimes they cannot meet the needs of data analysis. Here is another type——radar chart, which is equivalent to a parallel coordinates plot, with the axes arranged radially, and also a useful way to display multivariate observations with […]
-
How to Calculate Summation in Same or Separate Sequence in Excel
If you need to calculate summation of numbers, let Excel do it for you. It might be easy when it’s in same sequence but a little bit difficult in separate sequence. So let’s take a look at the tip you can complete it in a simple way. In Same Sequence 1. Drag to select numbers […]
