Highlight the cells
(Format Cells)(Alignment tab)
In the Vertical drop-down list select "Top" or "Bottom"


"Centre top to bottom excel" <Centre top to bottom
wrote in message
...
Within a highlighted area - specific cells only.