Excel Solutions

How to Password Protect VBA Codes in Your Excel Worksheet

Except for setting passwords for your Excel files and worksheets, now you can also password protect VBA codes. In this article, we will show you the method to fulfill this task. VBA codes in a macro-enabled workbook are certainly very essential to your work. Hence, you need to protect those codes. Among all the protection methods, you can set passwords for the codes. And below are the steps about this task. Protect VBA Codes Open the target file that contains the VBA codes that you...

Read more »

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 »