ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Center across selection" rather than "Merge cells" (https://www.excelbanter.com/excel-discussion-misc-queries/209059-center-across-selection-rather-than-merge-cells.html)

Elardus

"Center across selection" rather than "Merge cells"
 
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon through the
toolbars "Customization" process but unfortunately I cannot find "Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion€ťalways via the menu.... Or
create an icon through a macro€¦

Can you please add an icon for €śCenter across selection€ť in the "Formatting"
toolbar? Better still, dont even have the €śMerge cells€ť icon there.
Horizontal merging leads to all kind of problems€¦..


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Bob Phillips[_3_]

"Center across selection" rather than "Merge cells"
 
You could easily create a macro to do it and assign it to a toolbar button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon through
the
toolbars "Customization" process but unfortunately I cannot find "Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the menu....
Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc




Don Guillett

"Center across selection" rather than "Merge cells"
 
Here is the one I use in my personal.xls assigned to a toolbar button right
next to the unmerge button

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon through
the
toolbars "Customization" process but unfortunately I cannot find "Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the menu....
Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc




Don Guillett

"Center across selection" rather than "Merge cells"
 
I didn't realize that you had posted and posted and posted. GEEZ

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon through
the
toolbars "Customization" process but unfortunately I cannot find "Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the menu....
Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc




Don Guillett

"Center across selection" rather than "Merge cells"
 
Not meant for you Bob

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon through
the
toolbars "Customization" process but unfortunately I cannot find "Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the menu....
Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc




Bob Phillips[_3_]

"Center across selection" rather than "Merge cells"
 
No, nobody calls me GEEZ <G

--
__________________________________
HTH

Bob

"Don Guillett" wrote in message
...
Not meant for you Bob

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon through
the
toolbars "Customization" process but unfortunately I cannot find "Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the
menu.... Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc






Gord Dibben

"Center across selection" rather than "Merge cells"
 
I posted the same code to his other thread.

Time to start ignoring these multi-posts center across selection


Gord

On Wed, 5 Nov 2008 06:57:32 -0600, "Don Guillett"
wrote:

I didn't realize that you had posted and posted and posted. GEEZ



Don Guillett

"Center across selection" rather than "Merge cells"
 

Are you sure??
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
No, nobody calls me GEEZ <G

--
__________________________________
HTH

Bob

"Don Guillett" wrote in message
...
Not meant for you Bob

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon
through the
toolbars "Customization" process but unfortunately I cannot find
"Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the
menu.... Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc







John C[_2_]

"Center across selection" rather than "Merge cells"
 
It is Bob's pre-First name, as in GEEZ Bob, what'd you do this time? :)
--
** John C **


"Don Guillett" wrote:


Are you sure??
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
No, nobody calls me GEEZ <G

--
__________________________________
HTH

Bob

"Don Guillett" wrote in message
...
Not meant for you Bob

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon
through the
toolbars "Customization" process but unfortunately I cannot find
"Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the
menu.... Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc








Bob Phillips[_3_]

"Center across selection" rather than "Merge cells"
 
No, that is usually WTF Bob, what'd you do this time? <bg

--
__________________________________
HTH

Bob

"John C" <johnc@stateofdenial wrote in message
...
It is Bob's pre-First name, as in GEEZ Bob, what'd you do this time? :)
--
** John C **


"Don Guillett" wrote:


Are you sure??
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
No, nobody calls me GEEZ <G

--
__________________________________
HTH

Bob

"Don Guillett" wrote in message
...
Not meant for you Bob

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which
is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon
through the
toolbars "Customization" process but unfortunately I cannot find
"Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the
menu.... Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based Newsreader
and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc










John C[_2_]

"Center across selection" rather than "Merge cells"
 
Sorry, you're right, I saw it on the edited for TV portion, it was badly
dubbed on further inspection :)
--
** John C **

"Bob Phillips" wrote:

No, that is usually WTF Bob, what'd you do this time? <bg

--
__________________________________
HTH

Bob

"John C" <johnc@stateofdenial wrote in message
...
It is Bob's pre-First name, as in GEEZ Bob, what'd you do this time? :)
--
** John C **


"Don Guillett" wrote:


Are you sure??
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
No, nobody calls me GEEZ <G

--
__________________________________
HTH

Bob

"Don Guillett" wrote in message
...
Not meant for you Bob

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bob Phillips" wrote in message
...
You could easily create a macro to do it and assign it to a toolbar
button.

--
__________________________________
HTH

Bob

"Elardus" wrote in message
...
I use "Center across selection" and almost never "Merge cells", which
is
generally a bad choice (across columns anyway).

I wish to add an icon or otherwsie modify the "Merge Cells" icon
through the
toolbars "Customization" process but unfortunately I cannot find
"Center
across selection" amonst the "Commands - Fomat"choices.

Which means I have to do my "Cnter cross seletion"always via the
menu.... Or
create an icon through a macro.

Can you please add an icon for "Center across selection" in the
"Formatting"
toolbar? Better still, don't even have the "Merge cells" icon there.
Horizontal merging leads to all kind of problems...


----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based Newsreader
and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc












All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com