How to Create Price Tags in Excel (with Quick Steps)

In this article, we will demonstrate how to create price tags in Excel with a sample data column. Remember one thing, you can change the data according to ways that will serve your purposes.

How to Create Price Tags in Excel: Step-by-step Procedures

Suppose we have Sample Data of Product, Product ID, Type, and Price that are required to create a price tag. First of all, we will add extra columns other than the aforementioned types of columns to create a price tag in Excel.

⦿ Step 1: Add Extra Columns to Join the Text

• First of all, we will create columns with Title and sample side by side like the followings:

• To do so, we will use the TEXTJOIN function to combine Row 4 with the corresponding data in the other rows.
• So, to do the functionality, we will enter the following equation in cell G5.

• So now, drag the fill handle downwards to complete the series.

• Secondly, we will use the TEXTJOIN function to combine Row 4 with the corresponding data in the other rows.
• Now, to do the job, we will enter the following equation in cell H5.

• Again, drag the fill handle down to complete the sequence.

• Thirdly, we will again use the TEXTJOIN function to combine Row 4 with the corresponding data in the other rows.
• Now, we will enter the following equation in cell I5.

• Further, we will drag the fill handle downward to complete the series.

• In this last column, we will use the TEXTJOIN function to combine Row 4 with the corresponding data in the other rows.
• Now, we will enter the following equation in cell J5.

• Again, like in the many previous steps, now, drag the fill handle downward to complete the series.

⦿ Step 2: Create Price Tags Within a Cell

• At this moment, we will combine cells from the extra columns and combine them under the Price Tag.
• We have used the following formula to serve that purpose.

• Last but not least, we will select the following Home >> Alignment >> Wrap Text.

• To see the full cell, we will double-click on the row like the image below. (Or use the AutoFit Row Height command.)

• Now to complete the Price Tag column, we will drag the fill handle down like in the image below.

• Like the following image, we will select multiple rows.

• Now double-click on the mouse when the Excel cursor turns into like in the following image.

• Now we have the Price tag column. Further, you can modify your tag according to your preference.

• Select a wide column, if not wide make it wide and select AutoFit Column Width.

• Again, select all rows and select AutoFit Row Height.

• Our final table containing data for the price tags is here as in the image below.

Read More: How to Make Name Tags in Excel

Download Practice Workbook

You can download the practice workbook from the following download button.

Conclusion

Follow these steps and stages on how to create price tags in excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments.

Related Articles

• Smart Tags in Excel: Definition & Different Uses
• How to Add Tags in Excel
• How to Add Tag to Properties in Excel
• How to Use Multiple Tags in One Cell in Excel
• How to Filter Tags in Excel

<< Go Back to Tags in Excel | Data Analysis with Excel | Learn Excel