G
Guest
Is is possible to use Center Across Selection or something similar for a few
cells in a column, for example E4:E7?
cells in a column, for example E4:E7?
B
Bob I
You can if the cells are merged first.
G
Guest
Hi,
Only if you use merge, although it is rubbish!
Cheers
Dazza
Only if you use merge, although it is rubbish!
Cheers
Dazza
G
Guest
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.
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.
G
Guest
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.
use Format | Cells | [Alignment] and in the Horizontal alignment selection
you can choose Center Across Selection.
G
Guest
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
Format Cells window.
Andrea Jones
www.stratatraining.co.uk
www.allaboutoffice.co.uk
G
Guest
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.
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.
G
Guest
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
be displayed from bottom to top, do this:
Format Cells - > Alignment -> Change to 90 Degrees
Change VERTICAL alignment to CENTER
HTH,
Barb Reinhardt
G
Guest
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!
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!
G
Guest
Merge the cells together (Highlight the cells, Format, Cell, Alignment, Merge
Cells). On the same tab, also choose Vertical (alignment) Center.
Cells). On the same tab, also choose Vertical (alignment) Center.
- Joined
- Aug 31, 2010
- Messages
- 1
- Reaction score
- 0
After spending too much time looking for a solution to this and not finding one I eventually just set the text colour of the other items to white then put the border around the selection. You leave one item in black and it'll be in the center if you have an odd number of cells otherwise it will just have to be a bit off center.
- Joined
- Nov 19, 2006
- Messages
- 23
- Reaction score
- 0
WOW,
Half of the replies shows that the question was not really read.
Half of the replies shows that the question was not really read.