copy one cell then paste special format only for all the rows.