Excel File Recovery

3 Quick Methods to Input Same Contents into Multiple Cells in Your Excel

Sometimes you need to input same contents into multiple cells in the worksheet. Here we will introduce 3 methods to fulfill this task quickly. Suppose now you need to input the content “DataNumen Excel Repair” into the first cell of each month. Instead of inputting into those cells one by one, now you can also use the 3 methods. Method 1: Use Copy and Paste Feature The copy and paste is a very common feature in Excel. And here you can also input the contents into corresponding...

Read more »

How to Make Your Cell Values More Intuitive via Icon Sets in Excel

In Excel, you can use the icon sets to mark cells with different values. And in this article, we will talk about how to use this feature in Excel. Icon sets is a very useful feature in Excel. It is also a small feature of the conditional formatting. Suppose now you need to mark cells for the sales volume in the worksheet. Instead of ranking cells, now you can also use the different icons to mark different values in the cells, with icon sets, so to make these values more intuitive, as...

Read more »

2 Methods to Create a Chart in an Excel Chart Sheet

If you want to create a chart in an Excel chart sheet, you can use the 2 methods in this article. You will certainly create a chart for a range in Excel. Sometimes instead of putting the chart in the same worksheet, you need to input the chart into a new chart sheet. Now you can follow the steps of the 2 methods below. Method 1: Insert a Chart Sheet Now you need to create a chart for the sales volume. Right click any of a sheet tab in the workbook. And then choose the option...

Read more »