Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default "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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default "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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default "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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default "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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default "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





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default "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





  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default "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


  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default "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






  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,358
Default "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







  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default "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











  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,358
Default "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










Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
"Center Across Selection" icon in excel 2003 no merge dan Excel Discussion (Misc queries) 1 November 30th 05 06:14 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"