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.