Sorry, cannot do that the way you've requested.
Some Options are
1) to leave cells to the right empty and turn off word-wrap in that cell,
any text will extend out over adjacent colums in that row.
2) select several cells along with that one in the same row and use
Format | Cells | [Alignment] and in the Horizontal, choose "Center Across
Selection"
3) select that cell and more on the same row and MERGE them into one cell.
Initially the entry in that will be centered, but you can then align it to
the left or right using standard format options.
Hope this helps some with the problem.