Excel Solutions

How to Password Protect Specific Ranges in Your Excel Worksheet

The protected worksheet can protect data security very well. In addition, we will show you how to edit specific ranges in a protected worksheet. In our previous article, we have talked about protecting worksheet. And you may refer to it to see how it works: How to Protect Your Excel Worksheets with Passwords. But sometimes you need to send this file to other people, and they will modify certain area. For example, in this file, you need those sales representatives to check their sales...

Read more »

How to Use the Header & Footer Feature in Your Excel (Part I)

The header & Footer feature in Excel is a very useful functionality. Therefore, in this article, we are going to talk about this feature in detail. In Excel, if you want to insert page numbers or other elements in a worksheet, you can use the head & Footer feature. And it is especially useful when you need to print the worksheet. Insert Page Number In this workbook, you can see that there are two different data sets about sales volume. And now you need to print it. But without...

Read more »

How to Use the Header & Footer Feature in Your Excel (Part II)

In the previous article, we have talked about the page numbers and inserting the automatically generated contents. And now we will continue demonstrate about other usages of header & footer. Except for the page numbers and other elements, you can also insert images to make the worksheet more unique. And one of the methods is inserting images into it. Insert Background Picture into Worksheet This is different from inserting an image into a worksheet directly. In addition, if you need...

Read more »