Excel 2010 - apply same formatting as header cell
Tried the search but didn't get any useful results.
In excel 2010, if I have a header row containing 200 columns, and the
first cell of each column in the first row is formatted in a different way
- how do I quickly copy the formatting down to other cells in the same
column?
e,g,
row 1 -- F1 F2 F3 F4.................F2000 row 2 -- V1 V2 V3
V4.................V2000 row 3 -- X1 X2.......................X2000
How do i quickly copy the formaating from F1 onto V1, X1, similarly F2
onto V2, X2...without doing that for each column?
Thanks J