Excel File Recovery

How to Create and Manage a Custom Table Style in Your Excel Worksheet

There are many table styles in your Excel worksheet. But instead of using the pre-defined styles, you can also create your own custom table style in Excel. When you create a new table in the worksheet, you will see the default table style in the range. With different colors in adjacent rows, you can check values more convenient. But if you are bored with the default table style, you can also change it. You can click the button “Format as Table” and open the style list. In the image...

Read more »

How to Quickly Add Comments to Cells in Your Excel Worksheet via VBA

In certain circumstance, you need to copy comments into designated cells. Here we will introduce a quick method to finish this task. In the image below, you can see there are two comments in the worksheet. And to make the interface cleaner without hiding those comments, you can copy comments into certain cells. If you do this task manually, you will certainly spend a lot of time, especially when there are many comments. Hence, you may refer to the method below. Copy Comments into...

Read more »

How to Quickly Take a Screenshot and Clip it via Your Excel

Screenshot is a very practical feature in Excel. Here we will demonstrate how to take a screenshot and clip it in your Excel worksheet. Sometimes you will take a screenshot of other application and then insert the image into the Excel worksheet that you are working with. You will probably use the print screen feature in your computer or third party screenshot tool. When you finish the screenshot, you will insert the image into this Excel worksheet. Although this is the most common way, it is...

Read more »