Vertical - Center Across Selection

[smccarvi]

Is is possible to use Center Across Selection or something similar for a few
cells in a column, for example E4:E7?

 

[Bob I]

You can if the cells are merged first.

 

[DazzaData]

Hi,

Only if you use merge, although it is rubbish!

Cheers

Dazza

 

[ShaneDevenshire]

Hi,

Now that's a cute question!

With the E1:E5 cell selected you could do Merge and Center and then do
Vertical, Center.

Of course this is really not quite the same thing.

 

[JLatham]

Yes, type your entry into the first cell (E4) and then select all 3 cells,
use Format | Cells | [Alignment] and in the Horizontal alignment selection
you can choose Center Across Selection.

 

[Andrea Jones]

Merge them and then use the vertical centring under the alignment section of
Format Cells window.

Andrea Jones
www.stratatraining.co.uk
www.allaboutoffice.co.uk

 

[JLatham]

My apology - I misread things - I realize you're looking for VERTICAL
centering, not horizontal centering. For that you would need to merge the
cells involved and then choose the Cell | Format | Alignment and center
vertically.

Having difficulty viewing things in IE browser today, so if this is a repeat
answer, again my apologies, I can't even see my original reply at the moment.

 

[Barb Reinhardt]

Yes, but it would keep the upper left data entry. If you want hte data to
be displayed from bottom to top, do this:

Format Cells - > Alignment -> Change to 90 Degrees
Change VERTICAL alignment to CENTER

HTH,
Barb Reinhardt

 

[carter]

It's easy, all you have to do is highlight the cells you want centered, then
right click and select "Format Cells" then select the "Allignment" tab select
the drop down box for either Horizontal or Verticle and select center.

Good Luck!

 

[Karin]

Merge the cells together (Highlight the cells, Format, Cell, Alignment, Merge
Cells). On the same tab, also choose Vertical (alignment) Center.