Register
Log In
Unanswered
Home
New Member
June 25, 2016
Offline
I use the format cells - center across selection quite often and try to avoid Merge & Center commands.
I've tried to find a command to add to my quick access tool bar, but have never found such a button.
Does anyone know if it exists and what is called?
Cheers.
Bert
July 16, 2010
Offline
Hi Bert,
I don't think there's a command that exists for that, but you could record your own Macro and then assign it to an icon in your QAT.
Mynda
Dashboards
Power Query
Power Pivot
July 30, 2015
Offline
Bert
Further to Mynda's post, here is the code that I use for a button on my QAT to do what you're after (plus wrap text within the cell):
Sub WrapAcross() On Error GoTo NoStyle ' If Wrap Across is not available as a style Selection.Style = "WrapAcrossSelection" 'Modify this style to change the formatting selections Exit Sub NoStyle: ' If Wrap Across style is not available With Selection .HorizontalAlignment = xlCenterAcrossSelection .VerticalAlignment = xlCenter .WrapText = True .Orientation = 0 .ShrinkToFit = False .MergeCells = False End With End Sub
Most Users Ever Online: 57
Currently Online: Max Neumann
11 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
