MS Excel

Part 1: pdf to excel

  1. Download the NU pdf file: Download
  2. Search by 'pdf to excel' and go to 'pdf2go.com' and convert to excel
  3. Open the merged excel>Enable editing; Remove all rows for title (carefully notice the line after each title if a single line was broken to two line or not); Select all rows and columns>Unselect 'Merge & center' from Home menu
  4. Select Data>Filter; Now filter dropdown will appear in each column
  5. First dropdown>Unselect Blanks
  6. Now copy the full filtered sheet to a new one
  7. Create two blank rows after the first row
  8. Select first column>Data>Text to Columns>Delimited>Next>Other '/'>Next>Finish

Part 2: excel to seat card

Considering you have a excel file with student list

  1. Mailings > Start Mail Merge > Labels (30 per page)
  2. Display all borders
  3. Write your labels:
    Name:
    Roll:
  4. Mailings > Select Recipients > Use an existing list (browse to select your excel file)
  5. Mailings > Insert Merge Field > choose and insert your labels
  6. Mailings > Update Labels
  7. Mailings > Finish & Merge > Edit Individual Documents > ok

Labels: ,

Edit This post
© copyright-2020 Rejaul