S.S.C (10 th Class) IDENTIFICATION REGISTER SOFTWARE WITH BONAFIDE (Photo's insert option)

 *TS S.S.C (10 th Class) IDENTIFICATION REGISTER SOFTWARE WITH BONAFIDE( Photo's insert option)

Instructions to Prepare Identification Register with Photos

1. Enable Macros

• When opening the Excel file, always enable macros.

• A prompt will appear just below the formula bar—click "Enable Content" to activate macros.

2. Organize Student Photos

• Create a folder on your computer and place all student photos inside.

• Name each photo using the serial number corresponding to the student's N.R. S.No (e.g., 1, 2, 3, etc.).

3. Paste Folder Path in Excel

• Right-click the folder containing the photos while holding the Shift key.

• From the popup menu, select "Copy as path".

• Go to the yellow-colored cell in the "Register" sheet of the Excel file.

• Paste the copied path into the cell, then remove the quotation marks at both ends of the path.

4. Print the Identification Register

• In the green-colored cell of the "Register" sheet, enter 1 and take a printout on ledger paper.

• Change the number to 2, print again.

• Repeat this process for all students by entering numbers from 1 to the last serial number.

• After printing all entries, spiral-bind the pages to maintain an official office record.