Office Solutions

How to Quickly Copy a Cell Down or to the Right in Your Excel Worksheet

Sometimes in your Excel worksheet, you need to input the same contents into multiple cells. And in this article, we will show you how to fulfill this task by copying a cell down or to the right in worksheet. In certain circumstance, you need to input the same contents into a range. If those cells are adjacent, you can first input the contents into a cell and then copy it down or to the right. And the target area can be a cell or a range. Instead of using the copy and paste feature or the...

Read more »

How to Sort Cells by Cell Colors in Your Excel Worksheet

You will use different colors for different cells according to the values in those cells. And here we will introduce the method to sort cells by cell colors in your Excel worksheet. In an Excel worksheet, you will certainly use different colors to mark different cells. And the Excel worksheet may be similar to the image below. Several days ago, you have used different colors for different cells. And now you need to sort this column by the cell colors. And the steps below will show you...

Read more »

How to Combine Column Chart and Line Chart in One Chart in Your Excel

Sometimes you need to show different data sets in a chart, and the chart types also need to be different. Hence, in this article, you can learn how to combine column chart and line chart in one chart. Column chart and line chart are two different chart types in Excel. But sometimes you need to use these two types in one chart. For example, you need to show the data of sales volume in column chart. At the same time, you want to display the monthly sales growth in line chart in the same...

Read more »