Excel Solutions

How to Use Advanced Filter to Filter Data with Complex Criteria in Your Excel

You will always use the feature of filtering data in Excel. Today we will show you how to filter data with complex criteria by advanced filter in Excel. Suppose now you need to filter data in the two columns. You can certainly filter data through the feature of “Sort & and Filter”. But if your criteria are complex, you can also use advanced filter in the worksheet. And we will show you how to use the advanced filter to filter data in Excel. Filter Data with Complex Criteria ...

Read more »

How to Insert Pictures into Cells in Your Excel Worksheet

It is easy to insert pictures into Excel worksheets. In this article, we will show you how to embed pictures into cells. In general, you cannot insert an image into a cell directly. But with additional settings, the image can stay in the designated cell. Insert Pictures into Worksheets Here we will demonstrate the steps to insert an image into the worksheet. Click the tab “Insert” in the ribbon. Next click the button “Picture” in the toolbar. In the “Insert Picture”...

Read more »

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 »