ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TOOLBAR button or Keyboard Shortcut FOR Center Across Selection?? (https://www.excelbanter.com/excel-discussion-misc-queries/185475-toolbar-button-keyboard-shortcut-center-across-selection.html)

RajenRajput1

TOOLBAR button or Keyboard Shortcut FOR Center Across Selection??
 
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen

Bob Phillips

TOOLBAR button or Keyboard Shortcut FOR Center Across Selection??
 
If you create a macro that does it, you can add that macro to the QAT, it is
an option in the QAT customization.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"RajenRajput1" wrote in message
...
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen




RajenRajput1

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
....

Does that mean that any macro can be added to the Quick Acess Toolbar, and
it will always appear each time Excel loads?

That's neat. I am sure I can find (or record and tweak) the code and do this.

Thanks.



"Bob Phillips" wrote:

If you create a macro that does it, you can add that macro to the QAT, it is
an option in the QAT customization.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"RajenRajput1" wrote in message
...
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen





Bob Phillips

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
If you put in personal (.xlsb in my case), yes it will be. Just create the
macro, right-click the QAT, select 'Customize the Quick Access Toolbar...',
choose Macros from the first dropdown, then select the macro from the list,
and Add it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"RajenRajput1" wrote in message
...
...

Does that mean that any macro can be added to the Quick Acess Toolbar, and
it will always appear each time Excel loads?

That's neat. I am sure I can find (or record and tweak) the code and do
this.

Thanks.



"Bob Phillips" wrote:

If you create a macro that does it, you can add that macro to the QAT, it
is
an option in the QAT customization.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"RajenRajput1" wrote in message
...
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick
access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen







RajenRajput1

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
Thank you for the help.

I made the macro and saved it in personal.xlsb and it works fine, ONLY when
one Excel window is open.

When I open another Excel window, I get a message saying something like,

"File In Use - Personal.xlsb is locked for editing" "Read only, Notify or
Cancel"

Which is soon going to get annoying as I open many windows many times. How
could I get around this ?

Thank you,

Rajen

"Bob Phillips" wrote:

If you put in personal (.xlsb in my case), yes it will be. Just create the
macro, right-click the QAT, select 'Customize the Quick Access Toolbar...',
choose Macros from the first dropdown, then select the macro from the list,
and Add it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"RajenRajput1" wrote in message
...
...

Does that mean that any macro can be added to the Quick Acess Toolbar, and
it will always appear each time Excel loads?

That's neat. I am sure I can find (or record and tweak) the code and do
this.

Thanks.



"Bob Phillips" wrote:

If you create a macro that does it, you can add that macro to the QAT, it
is
an option in the QAT customization.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"RajenRajput1" wrote in message
...
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick
access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen







Gord Dibben

TOOLBAR button or Keyboard Shortcut FOR Center Across Selection??
 
Assign this to a button.

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 Tue, 29 Apr 2008 03:59:00 -0700, RajenRajput1
wrote:

Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen



Gord Dibben

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
Open all workbooks in one instance of Excel rather a new instance Excel for each
workbook you open.


Gord Dibben MS Excel MVP

On Tue, 29 Apr 2008 07:26:01 -0700, RajenRajput1
wrote:

Thank you for the help.

I made the macro and saved it in personal.xlsb and it works fine, ONLY when
one Excel window is open.

When I open another Excel window, I get a message saying something like,

"File In Use - Personal.xlsb is locked for editing" "Read only, Notify or
Cancel"

Which is soon going to get annoying as I open many windows many times. How
could I get around this ?

Thank you,

Rajen

"Bob Phillips" wrote:

If you put in personal (.xlsb in my case), yes it will be. Just create the
macro, right-click the QAT, select 'Customize the Quick Access Toolbar...',
choose Macros from the first dropdown, then select the macro from the list,
and Add it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"RajenRajput1" wrote in message
...
...

Does that mean that any macro can be added to the Quick Acess Toolbar, and
it will always appear each time Excel loads?

That's neat. I am sure I can find (or record and tweak) the code and do
this.

Thanks.



"Bob Phillips" wrote:

If you create a macro that does it, you can add that macro to the QAT, it
is
an option in the QAT customization.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"RajenRajput1" wrote in message
...
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick
access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen








RajenRajput1

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
Opening all the files in one instant is great, however I prefer not to do it
as I can subsequently move and resize individual windows on the screen.

If there is no way to get around this, then so be it.

Thanks for the advice, well spotted !

Rajen

"Gord Dibben" wrote:

Open all workbooks in one instance of Excel rather a new instance Excel for each
workbook you open.


Gord Dibben MS Excel MVP

On Tue, 29 Apr 2008 07:26:01 -0700, RajenRajput1
wrote:

Thank you for the help.

I made the macro and saved it in personal.xlsb and it works fine, ONLY when
one Excel window is open.

When I open another Excel window, I get a message saying something like,

"File In Use - Personal.xlsb is locked for editing" "Read only, Notify or
Cancel"

Which is soon going to get annoying as I open many windows many times. How
could I get around this ?

Thank you,

Rajen

"Bob Phillips" wrote:

If you put in personal (.xlsb in my case), yes it will be. Just create the
macro, right-click the QAT, select 'Customize the Quick Access Toolbar...',
choose Macros from the first dropdown, then select the macro from the list,
and Add it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"RajenRajput1" wrote in message
...
...

Does that mean that any macro can be added to the Quick Acess Toolbar, and
it will always appear each time Excel loads?

That's neat. I am sure I can find (or record and tweak) the code and do
this.

Thanks.



"Bob Phillips" wrote:

If you create a macro that does it, you can add that macro to the QAT, it
is
an option in the QAT customization.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"RajenRajput1" wrote in message
...
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick
access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen









RajenRajput1

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
How do I do it ??

Is it the same Macro thing as Bob Phillip's response?

Kind regards,

Rajen

"Gord Dibben" wrote:

Assign this to a button.

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 Tue, 29 Apr 2008 03:59:00 -0700, RajenRajput1
wrote:

Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen




Bob Phillips

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
Even a read only personal will still have the macro available.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"RajenRajput1" wrote in message
...
Opening all the files in one instant is great, however I prefer not to do
it
as I can subsequently move and resize individual windows on the screen.

If there is no way to get around this, then so be it.

Thanks for the advice, well spotted !

Rajen

"Gord Dibben" wrote:

Open all workbooks in one instance of Excel rather a new instance Excel
for each
workbook you open.


Gord Dibben MS Excel MVP

On Tue, 29 Apr 2008 07:26:01 -0700, RajenRajput1
wrote:

Thank you for the help.

I made the macro and saved it in personal.xlsb and it works fine, ONLY
when
one Excel window is open.

When I open another Excel window, I get a message saying something like,

"File In Use - Personal.xlsb is locked for editing" "Read only, Notify
or
Cancel"

Which is soon going to get annoying as I open many windows many times.
How
could I get around this ?

Thank you,

Rajen

"Bob Phillips" wrote:

If you put in personal (.xlsb in my case), yes it will be. Just create
the
macro, right-click the QAT, select 'Customize the Quick Access
Toolbar...',
choose Macros from the first dropdown, then select the macro from the
list,
and Add it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"RajenRajput1" wrote in
message
...
...

Does that mean that any macro can be added to the Quick Acess
Toolbar, and
it will always appear each time Excel loads?

That's neat. I am sure I can find (or record and tweak) the code
and do
this.

Thanks.



"Bob Phillips" wrote:

If you create a macro that does it, you can add that macro to the
QAT, it
is
an option in the QAT customization.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in
my
addy)

"RajenRajput1" wrote in
message
...
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for
either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for
center
across selection, or perhaps a way of placing a button on the
quick
access
toolbar?

Merging cells is too easy to do and that is why I prefer it,
however
formatting and selecting cells is becoming an issue with merging,
and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen











Bob Phillips

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
That could be the macro that I was suggesting, although I wouldn't be so
profligate as to repeat Selection <g

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

But I was thinking of a more basic macro, not a toggle

Sub CentreAcrossSelection()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"RajenRajput1" wrote in message
...
How do I do it ??

Is it the same Macro thing as Bob Phillip's response?

Kind regards,

Rajen

"Gord Dibben" wrote:

Assign this to a button.

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 Tue, 29 Apr 2008 03:59:00 -0700, RajenRajput1
wrote:

Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick
access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen






Gord Dibben

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
In one instance of Excel you can open multiple workbooks then go to WindowNew
Window and WindowArrange to get several windows with a workbook in each window.


Gord

On Tue, 29 Apr 2008 08:55:00 -0700, RajenRajput1
wrote:

Opening all the files in one instant is great, however I prefer not to do it
as I can subsequently move and resize individual windows on the screen.

If there is no way to get around this, then so be it.

Thanks for the advice, well spotted !

Rajen

"Gord Dibben" wrote:

Open all workbooks in one instance of Excel rather a new instance Excel for each
workbook you open.


Gord Dibben MS Excel MVP

On Tue, 29 Apr 2008 07:26:01 -0700, RajenRajput1
wrote:

Thank you for the help.

I made the macro and saved it in personal.xlsb and it works fine, ONLY when
one Excel window is open.

When I open another Excel window, I get a message saying something like,

"File In Use - Personal.xlsb is locked for editing" "Read only, Notify or
Cancel"

Which is soon going to get annoying as I open many windows many times. How
could I get around this ?

Thank you,

Rajen

"Bob Phillips" wrote:

If you put in personal (.xlsb in my case), yes it will be. Just create the
macro, right-click the QAT, select 'Customize the Quick Access Toolbar...',
choose Macros from the first dropdown, then select the macro from the list,
and Add it.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"RajenRajput1" wrote in message
...
...

Does that mean that any macro can be added to the Quick Acess Toolbar, and
it will always appear each time Excel loads?

That's neat. I am sure I can find (or record and tweak) the code and do
this.

Thanks.



"Bob Phillips" wrote:

If you create a macro that does it, you can add that macro to the QAT, it
is
an option in the QAT customization.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"RajenRajput1" wrote in message
...
Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of
these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick
access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and
center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen










Gord Dibben

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
It is a macro that you would assign to a button as Bob described for Excel 2007

Toggles the CAS on/off


Gord

On Tue, 29 Apr 2008 08:56:02 -0700, RajenRajput1
wrote:

How do I do it ??

Is it the same Macro thing as Bob Phillip's response?

Kind regards,

Rajen

"Gord Dibben" wrote:

Assign this to a button.

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 Tue, 29 Apr 2008 03:59:00 -0700, RajenRajput1
wrote:

Hi,

I use Excel 2007 at work and Excel 2003 at home.

Is there a keyboard shortcut to center across selection for either of these
versions, pref 2007?

And secondly, does anyone know if there is a toolbar button for center
across selection, or perhaps a way of placing a button on the quick access
toolbar?

Merging cells is too easy to do and that is why I prefer it, however
formatting and selecting cells is becoming an issue with merging, and center
across selection has it's merits, but it's time consuming.

Thank for the advice, I hope someone can help.

Regards,

Rajen





Gord Dibben

TOOLBAR button or Keyboard Shortcut FOR Center Across Selectio
 
Bob

Please elucidate on the profligacy of repeating "Selection"

I cannot get the macro to work without using xlCenterAcrossSelection even
though inside the "with selection"


Gord

On Tue, 29 Apr 2008 17:48:46 +0100, "Bob Phillips"
wrote:

That could be the macro that I was suggesting, although I wouldn't be so
profligate as to repeat Selection <g

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

But I was thinking of a more basic macro, not a toggle

Sub CentreAcrossSelection()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub




All times are GMT +1. The time now is 12:48 PM.

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