You could just highlight the entire column and then select your formatting
options. As far as making everything upper case, I don't believe there is an
upper case formatting option, though you could use an UPPER formula on a
target cell.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Misha" wrote:

Is there a way of font formatting an enitre column so that it will be in a
particular case, colour, font?
Thanks