In this step, we will give a name to our Salary Sheet so that we can easily find out that data table. Step-4: Using Named Range in Main Salary Sheet Read More: How to Make Salary Sheet in Excel with Formula (with Detailed Steps)

Moreover, we will click on that drop-down arrow > select an Id No.

Then, you can see a drop-down arrow on the right side of cell C9.

After that, click OK in the Data Validation dialog box.

Then, we will go to our Salary Sheet, and select cells B5:B15 as our source data.

Afterward, click on the upward arrow of the Source box to select the data source.

Then, from the Allow group > select List.

Then, a Data Validation dialog box will appear.

Furthermore, click on the Data Validation icon marked with a red color box > select Data Validation.

In the beginning, we will click on cell C9 > go to the Data tab.

in cell C9, and for reference, we will use the Salary Sheet. Step-3: Inserting Employee ID from Salary Sheet to Salary Slip Read More: How to Create Driver Salary Slip Format in Excel Whenever you print or use the slip the Date will be updated to the current date by itself.Īs a result, you can see the date of today in cell E6. The TODAY function returns the current day date.

To do so, first, we type the following formula using the TODAY function in cell F6.

In this step, we will add a date to the automatic salary slip.

Step-2: Adding Date to Automate Salary Slip Read More: How to Create Tally Salary Slip Format in Excel (With Easy Steps) Also, we add the company name and address. We have created the outlines using All Borders and Thick Outline Borders. In this step, we have created the outline for the automatic salary slip. Step-1: Creating Outline for Automatic Salary Slip

In the following article, we will describe some easy steps to create an automatic salary slip generator in Excel. Next, Using this Salary Sheet, we have created the following automatic salary slip.įurther, in this article, we will show you how to create such a salary slip with easy steps.Ĩ Steps to Create Automatic Salary Slip Generator Using Excel

In the following picture, you can see the overview of a Salary Sheet. Overview of a Salary Sheet and Automatic Salary Slip

Salary slip excel format