task2.py

# Example of how to add data validation for XLSX field A2

from openpyxl import load_workbook
from openpyxl.worksheet.datavalidation import DataValidation


data_file = '111.xlsx'
wb = load_workbook(filename=data_file)
page = wb['отчет']

dv = DataValidation(type="list", formula1="списки!A2:A4", allow_blank=False)
page.add_data_validation(dv)

a2 = page['A2']
dv.add(a2)

wb.save(data_file)