Excel File Recovery

4 Effective Methods to Insert Multiple Rows or Columns into Your Worksheet

Inserting rows or columns into a worksheet is a very easy process. But sometimes you need to insert multiple rows or columns into a worksheet. You can use the 4 methods in this article. Due to the need of a task, you will need to insert multiple rows or columns into a worksheet. The image below shows a list of product names. And now you need to insert 5 rows after row 8. And you can follow the steps below to learn those different methods. Method 1: Insert Manually This is the most...

Read more »

How to Format Cells with Color Scales in Your Excel Worksheet

In an Excel worksheet, you may need to format certain cells to make them different from others. Here we will introduce the method of using the color scales to fulfill this task. Sometimes in your Excel worksheet, you will format cells according to their values. For example, in the image below, now we need to format the cells according to the sales volume. And instead of formatting cells manually, now you can use the feature of color scales in Excel. Use Color Scales Select the...

Read more »

How to Quickly Select or Unselect all Checkboxes in Your Excel Worksheet by VBA

Checkbox is a good helper when you will analyze certain information. And in today’s article, we are going to introduce the method to quickly select or unselect all checkboxes in your Excel worksheet. Checkbox is a kind of form control object in Excel. You will sometimes mark some options by checkboxes. The image below demonstrates a list about the products. You can use the checkboxes to select or unselect certain products. While in some analysis, you will need to select all the...

Read more »