excel A到z 拉

任一单元格写入公式

=IF(ROW(A1)>26,"",CHAR(64+ROW(A1)))

或

=IF(ROW(A1)>26,"",SUBSTITUTE(ADDRESS(1,ROW(A1),4),1,))

下拉填充公式