I want to create a cell the widtth of the entire excel document so I can put
a heading on the document without effecting column size.

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.

--
Don Guillett
SalesAid Software

"milo1339" wrote in message
...
I want to create a cell the widtth of the entire excel document so I can
put
a heading on the document without effecting column size.

Don, Thank you very much for your help! It worked Perfectly.

Mike

"Don Guillett" wrote:

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.

--
Don Guillett
SalesAid Software

"milo1339" wrote in message
...
I want to create a cell the widtth of the entire excel document so I can
put
a heading on the document without effecting column size.

<<<"You can customize your toolbar to put the icon for this on the
toolbar"

Wasn't that *last available* in XL5.0?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don Guillett" wrote in message
...
select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.

--
Don Guillett
SalesAid Software

"milo1339" wrote in message
...
I want to create a cell the widtth of the entire excel document so I can
put
a heading on the document without effecting column size.

glad to help

--
Don Guillett
SalesAid Software

"milo1339" wrote in message
...
Don, Thank you very much for your help! It worked Perfectly.

Mike

"Don Guillett" wrote:

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.

--
Don Guillett
SalesAid Software

"milo1339" wrote in message
...
I want to create a cell the widtth of the entire excel document so I can
put
a heading on the document without effecting column size.

Don, How can I customize the toolbar to utilize it quickly?

"Don Guillett" wrote:

glad to help

--
Don Guillett
SalesAid Software

"milo1339" wrote in message
...
Don, Thank you very much for your help! It worked Perfectly.

Mike

"Don Guillett" wrote:

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.

--
Don Guillett
SalesAid Software

"milo1339" wrote in message
...
I want to create a cell the widtth of the entire excel document so I can
put
a heading on the document without effecting column size.

There is no "center across selection" button available unless it has been added
in 2007

I added a button and a macro to toggle on/off.

Sub TOGGLECENTERACROSS()
With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Else
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 25 Jun 2006 07:39:20 -0500, "Don Guillett"
wrote:

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.

Hi Gord, Thanks for your feedback but I don't know how to enter the info you
provided. Can you provide further assistance. I appreciate it.

Mike

"Gord Dibben" wrote:

There is no "center across selection" button available unless it has been added
in 2007

I added a button and a macro to toggle on/off.

Sub TOGGLECENTERACROSS()
With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Else
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 25 Jun 2006 07:39:20 -0500, "Don Guillett"
wrote:

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.

You're right. I forgot that I had added my own macro in personal.xls and
assigned to a custom button.

Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub

--
Don Guillett
SalesAid Software

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
There is no "center across selection" button available unless it has been
added
in 2007

I added a button and a macro to toggle on/off.

Sub TOGGLECENTERACROSS()
With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Else
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 25 Jun 2006 07:39:20 -0500, "Don Guillett"

wrote:

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.

Mike

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project by name and select it.

Right-click and InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo.

To place a button on a Toolbar...ToolsCustomizeCommandsMacros.

Drag the smiley-face button to your Toolbar.

Right-click and "Assign Macro". Select TOGGLECENTERACROSS and OK

Note: when you right-click you will also see "Change Button Image". There are
a bunch of button faces to pick from if you don't like smiley.


Gord

On Sun, 25 Jun 2006 12:26:02 -0700, milo1339
wrote:

Hi Gord, Thanks for your feedback but I don't know how to enter the info you
provided. Can you provide further assistance. I appreciate it.

Mike

"Gord Dibben" wrote:

There is no "center across selection" button available unless it has been added
in 2007

I added a button and a macro to toggle on/off.

Sub TOGGLECENTERACROSS()
With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Else
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 25 Jun 2006 07:39:20 -0500, "Don Guillett"
wrote:

select columnsright clickformatalignmenthorizontalcenter across.
You can customize your toolbar to put the icon for this on the toolbar
I do NOT recommend merge cells.



Gord Dibben MS Excel MVP