Select all the cells, FormatCellsAlignment, and in the Horizontal
dropdown, select Center across selection.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sethius" wrote in message
...
all i can manage to do is centre it in the cell. How do i put it accross
the
whole screen without dragging column A acrross the screen and the
centering
the text in it?