How to create labels in Excel

Create Cards for Excel is designed to make label cards from your data in a worksheet. With the tool's help, you will instantly get your records reshaped for printing or further processing. On this page, you'll learn how to use this add-in to get the needed layout.

How to use Create Cards

Click the Create Cards icon in the Transform group on the Ablebits Tools tab:
Run Ablebits Create Cards.

The Create Cards dialog window will appear:
Create labels from your data in Excel.

  1. By default, the add-in highlights the entire data range in your worksheet. You can select any other range or enter it using your keyboard.
  2. Click the Expand selection icon to have the entire table highlighted automatically.
  3. Use the Select range option to collapse the dialog window and choose the range you need:
    Select the range to create labels.
  4. If the top row in the selected table is a header, tick off this option.
    Tip. If you have more then one header row, click the "1 header row" phrase and enter the needed number:
    Enter the number of header rows.
  5. You can choose any number of columns with cards you want to see in the resulting worksheet. Just enter the necessary quantity in the Number of columns field or use the up and down arrows to adjust it.

    For example, if you pick 3, you will see three columns of cards in the resulting sheet.

    Tip. It is possible to create up to 80 columns with cards.
  6. You can add blanks between the cards for better visualization:
    • Select By empty row to separate groups of records with blank rows.
    • If you choose to get more than one column with the results, you can also divide them By empty column.
  7. Save original headers and formatting:
    • Tick the Add header checkbox to display all column headers as labels next to the values in your cards.
    • It is possible to keep the format of your original data by ticking the Preserve formatting checkbox.
    Note. If you choose to preserve formatting, the add-in will pick it from the first row for the headers and from the second row for the rest of the data.

Click the Create button to see the results in a new worksheet.

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard