Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Plantimacros
 
Posts: n/a
Default Excel should have a bar button to center across selection

As a selection of a range of cells, and the copy and paste action are afected
when crossing a merged cell, I prefer to center cells across selection, not
to merge them; it will be usefull to have a bar button with this command.

----------------
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...et.f unctions
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default Excel should have a bar button to center across selection

While I agree this would be a great built-in option, you can build your
own.

I use this macro

Public Sub CenterAcrossSelection()
On Error Resume Next
Selection.HorizontalAlignment = xlCenterAcrossSelection
On Error GoTo 0
End Sub

attached to a button on my custom toolbar.

In article ,
Plantimacros wrote:

As a selection of a range of cells, and the copy and paste action are afected
when crossing a merged cell, I prefer to center cells across selection, not
to merge them; it will be usefull to have a bar button with this command.

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
Visio button message in Excel Toni Excel Discussion (Misc queries) 0 November 29th 05 05:35 PM
How do I center category labels in Excel? Sarah Charts and Charting in Excel 7 July 13th 05 08:39 PM
Merge and Center button gall Excel Discussion (Misc queries) 0 May 11th 05 02:26 AM
adding a command button to an excel cell? betelguese Excel Discussion (Misc queries) 1 March 22nd 05 04:09 AM
In only Excel, my mouse behaves as if the left button is held dow. DanV Excel Discussion (Misc queries) 1 March 14th 05 08:35 AM


All times are GMT +1. The time now is 01:03 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"