Excel Tutorial: How To Make Name Tags In Excel 2016


Creating name tags is an essential task for any event, conference, or meeting. It helps attendees easily identify each other and fosters a sense of belonging and community. In this tutorial, we will walk you through the process of making professional-looking name tags in Excel 2016. Whether you are organizing a small gathering or a large-scale event, this tutorial will equip you with the skills to efficiently create name tags for your attendees.

Key Takeaways

  • Creating name tags is crucial for events, conferences, and meetings to facilitate identification and foster a sense of community.
  • Excel 2016 provides the necessary tools to efficiently make professional-looking name tags for any gathering.
  • Choosing the right font, adding design elements, and formatting the name tags are essential steps for a visually appealing result.
  • Setting the print area, previewing before printing, and adjusting formatting options are key in ensuring the name tags are printed perfectly.
  • Utilizing Excel for creating name tags can streamline the process and lead to a more organized event experience.

Setting up the Excel sheet

When creating name tags in Excel 2016, it's essential to set up the Excel sheet correctly to ensure a smooth and efficient process. Here's how to do it:

A. Open Excel 2016

Begin by opening the Excel 2016 program on your computer. You can do this by clicking on the Excel icon in your applications folder or by searching for it in the search bar.

B. Create a new workbook

Once Excel is open, create a new workbook by selecting "File" and then "New" from the top menu. This will open a new, blank workbook for you to work with.

C. Name the file

Before you begin entering any data, it's a good idea to name your file. This will make it easier to identify and locate later on. To name the file, click on "File" and then "Save As" from the top menu. Enter a descriptive name for the file and click "Save."

Entering the names

When creating name tags in Excel 2016, it’s important to start by entering the names of the individuals who will be receiving the tags. Here’s how to do it:

A. Decide on the font and size for the name tags

Before entering the names, it’s essential to decide on the font and size for the name tags. This will ensure consistency and readability. Choose a clear and legible font, such as Arial or Calibri, and a size that is large enough to be easily read, but not so large that it takes up too much space on the tag.

B. Enter the names in the first column

Once you’ve decided on the font and size, enter the names in the first column of your Excel worksheet. Each name should be entered into its own cell, starting from the top of the column and working your way down.

C. Use the fill handle to quickly populate the cells

To quickly populate the cells with the names, you can use the fill handle. Simply enter the first name, then click and drag the fill handle (the small square in the bottom right corner of the cell) down the column to fill in the remaining cells with the names. This can save you time and effort, especially if you have a long list of names to enter.

Adding Design Elements

When creating name tags in Excel 2016, it’s important to consider the design elements that will make your name tags visually appealing and easy to read. Here are some ways to enhance the look of your name tags:

Insert a border around the name tags

One way to make your name tags stand out is to add a border around them. This can be done by selecting the cells where the name tags are located and then going to the “Borders” option under the “Home” tab. From there, you can choose the style and color of the border to suit your preferences.

Consider adding a background color for visibility

To make the name tags more visible and eye-catching, you can add a background color to the cells. This can be done by selecting the cells and then going to the “Fill Color” option under the “Home” tab. Choose a color that contrasts well with the text color to ensure that the name tags are easy to read.

Experiment with different font styles for a professional look

Another way to enhance the appearance of your name tags is to experiment with different font styles. You can choose a professional-looking font that reflects the tone of the event or organization for which the name tags are being created. To change the font style, simply select the cells and then choose a different font from the “Font” option under the “Home” tab.

Formatting the name tags

When creating name tags in Excel 2016, it's important to pay attention to the formatting to ensure they look professional and polished. Here are a few tips on how to format name tags effectively:

A. Adjust column width and row height for the perfect size

Before inputting any names, it's essential to adjust the column width and row height to the perfect size for your name tags. This will ensure that the names fit neatly within the cells without being cut off or overflowing.

B. Center the names within the cells

Once the column width and row height are set, make sure to center the names within the cells. This will give the name tags a clean and organized appearance, making them easier to read and visually appealing.

C. Use formatting options to make the name tags visually appealing

Excel 2016 offers a variety of formatting options to make the name tags visually appealing. You can experiment with different font styles, sizes, colors, and borders to create a professional and eye-catching design for the name tags.

Printing the name tags

Once you have created your name tags in Excel, it's time to print them out. Here's how you can print name tags in Excel 2016:

A. Set the print area

To ensure that only the name tags are printed, you will need to set the print area in Excel.

1. Select the cells containing the name tags

  • Click and drag to select the cells containing the name tags

2. Set the print area

  • Go to the Page Layout tab
  • Click on Print Area
  • Select Set Print Area

B. Preview the name tags before printing

Before you print the name tags, it's a good idea to preview how they will look on the printed page.

1. Go to Print Preview

  • Click on the File tab
  • Select Print
  • Click on Print Preview

2. Adjust the settings

  • Use the settings in Print Preview to adjust the layout and appearance of the name tags

C. Print the name tags

Once you are satisfied with how the name tags look in Print Preview, you can go ahead and print them.

1. Select the printer

  • Ensure that the correct printer is selected in the Print dialog box

2. Adjust the print settings

  • Choose the number of copies you want to print
  • Adjust any other print settings as needed

3. Click Print

  • Click on the Print button to print the name tags


In conclusion, name tags are an essential part of various events and settings, allowing for easy identification and networking opportunities. Excel provides a user-friendly platform for creating personalized name tags, offering efficiency and customization options. We encourage our readers to explore the features of Excel 2016 for their name tag needs, and we look forward to hearing about your experiences and tips for using Excel for similar tasks.

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles