Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Configuration of cells
When I merge cells, Excel merges and centers the data to be placed
horizontally. However, the vertical alignment remains or is defaulted to "bottom". How can I make Excell to center the merge cells to show data center in either direction, vertical and horizontal? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Configuration of cells
Hi
Goto FormatCellsAlignment adjust Vertical HTH John "Odarit" wrote in message ... When I merge cells, Excel merges and centers the data to be placed horizontally. However, the vertical alignment remains or is defaulted to "bottom". How can I make Excell to center the merge cells to show data center in either direction, vertical and horizontal? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Configuration of cells
Thanks John. The problem is that one you go to another cells or a different
workbook, you have to again format the cells using the procedure you just mention. I was hoping to have it make "center-center" by default. Odarit "John" wrote: Hi Goto FormatCellsAlignment adjust Vertical HTH John "Odarit" wrote in message ... When I merge cells, Excel merges and centers the data to be placed horizontally. However, the vertical alignment remains or is defaulted to "bottom". How can I make Excell to center the merge cells to show data center in either direction, vertical and horizontal? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Configuration of cells
select all cells inside a worksheet and do what John says. It will affect all
cells. If you want the same effect for all sheets, then select all sheets you want, by keeping shift and clicking on tabs. "Odarit" wrote: Thanks John. The problem is that one you go to another cells or a different workbook, you have to again format the cells using the procedure you just mention. I was hoping to have it make "center-center" by default. Odarit "John" wrote: Hi Goto FormatCellsAlignment adjust Vertical HTH John "Odarit" wrote in message ... When I merge cells, Excel merges and centers the data to be placed horizontally. However, the vertical alignment remains or is defaulted to "bottom". How can I make Excell to center the merge cells to show data center in either direction, vertical and horizontal? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Configuration of cells
If you are not Vba phobic, then assign this sub to a button on a toolbar... '--- Sub MergeAndAlign() 'Jim Cone - Portland, Oregon USA. 'Centers text (h & v) when merging cells and vice versa. On Error GoTo Kaput If TypeName(Selection) = "Range" Then If Selection.Areas.Count 1 Then MsgBox "Select only one area.", vbInformation, _ "Merge Cells - Microsoft Excel" Exit Sub ElseIf Selection.Count 1 Then Application.ScreenUpdating = False If Selection.MergeCells Or IsNull(Selection.MergeCells) Then Selection.UnMerge Selection.VerticalAlignment = xlVAlignBottom Selection.HorizontalAlignment = xlHAlignGeneral Else Selection.Merge Selection.VerticalAlignment = xlVAlignCenter Selection.HorizontalAlignment = xlHAlignCenter End If Application.ScreenUpdating = True End If End If Exit Sub Kaput: Beep Application.ScreenUpdating = True End Sub -- Jim Cone Portland, Oregon USA (don't merge cells) "Odarit" wrote in message When I merge cells, Excel merges and centers the data to be placed horizontally. However, the vertical alignment remains or is defaulted to "bottom". How can I make Excell to center the merge cells to show data center in either direction, vertical and horizontal? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Configuration of cells
Thans you all. Now I am cooking with gas!
"Khoshravan" wrote: select all cells inside a worksheet and do what John says. It will affect all cells. If you want the same effect for all sheets, then select all sheets you want, by keeping shift and clicking on tabs. "Odarit" wrote: Thanks John. The problem is that one you go to another cells or a different workbook, you have to again format the cells using the procedure you just mention. I was hoping to have it make "center-center" by default. Odarit "John" wrote: Hi Goto FormatCellsAlignment adjust Vertical HTH John "Odarit" wrote in message ... When I merge cells, Excel merges and centers the data to be placed horizontally. However, the vertical alignment remains or is defaulted to "bottom". How can I make Excell to center the merge cells to show data center in either direction, vertical and horizontal? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
configuration progress message | Excel Discussion (Misc queries) | |||
general configuration? | Excel Discussion (Misc queries) | |||
configuration window at start | Excel Discussion (Misc queries) | |||
Status Bar Configuration area | Excel Worksheet Functions | |||
Configuration d'un TextBox | Excel Discussion (Misc queries) |