任一单元格写入公式
=IF(ROW(A1)>26,"",CHAR(64+ROW(A1)))
或
=IF(ROW(A1)>26,"",SUBSTITUTE(ADDRESS(1,ROW(A1),4),1,))
下拉填充公式