标签：Excel
-
How to Replace Specific Content in Excel Sheets More Precisely
Imagine that you have a grade table and need to replace all the “0” scores in it with “Fail”, how can you do it without replacing the “0” in other values like 60, 70? Is there a way to replace the specific content in Excel Spreadsheet more precisely? It’s a tricky situation cause normally the […]
-
How to Create an Uninterrupted Sequence in Microsoft Excel
When inserting or deleting some rows to Excel spreadsheet, the sequence number will be interrupted and become incoherent, which could also affect your counting. In fact, you can use a very simple Excel formula to create an uninterrupted sequence in a column. 1. Enter the formula: =ROW()-1 in the first cell of the sequence column. […]
-
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 Create a Pie Chart in Microsoft Excel
Pie chart is one of the most common used charts in Excel. It’s often used in market share analysis, market occupancy analysis and some other occasions since it can express the proportion of each area intuitively. The way to insert a pie chart in Excel is much like the method of making a line chart, […]
-
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 Insert Curly Braces in Microsoft Word and Excel
To satisfy certain requirements, you may need to insert some curly braces into Word document or Excel spreadsheet. But in addition to regular curly braces, sometimes the curly braces with customized size that can contain several lines of text are also needed. In this post, I’ll introduce 4 commonly used methods to insert both regular […]
-
How to Split Text from One Cell into Multiple Cells in Excel
Sometimes you copy some texts to Excel with the intention of splitting them into multiple columns, but it turns out that all the texts were put into the same column. To rearrange them manually is a heavy work. So how could you split the content into two or more cells in Excel without cutting and […]
