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



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




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






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








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


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







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








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



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












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





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









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




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


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
A button for Center Across Selection Jaleel Excel Discussion (Misc queries) 4 October 3rd 06 06:06 AM
Excel should have a bar button to center across selection Plantimacros Excel Worksheet Functions 1 November 30th 05 07:13 PM
shortcut to center text other than format toolbar? rdavia Excel Discussion (Misc queries) 2 May 5th 05 03:54 PM
Is there a keyboard shortcut to center data in a cell? Phil_K Excel Worksheet Functions 1 April 24th 05 01:55 AM
Center Across Selection Vertically Help. I am trying to center te. msond Excel Discussion (Misc queries) 1 March 29th 05 12:37 PM


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