"...to change row 4's..."
import openpyxl from openpyxl.styles import Font col_range = sh.max_column #get max columns in the worksheet for k in range(1, col_range + 1): sh.cell(row=4, column=k).font = Font(name='Arial', size=8)