Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A button for Center Across Selection | Excel Discussion (Misc queries) | |||
Excel should have a bar button to center across selection | Excel Worksheet Functions | |||
shortcut to center text other than format toolbar? | Excel Discussion (Misc queries) | |||
Is there a keyboard shortcut to center data in a cell? | Excel Worksheet Functions | |||
Center Across Selection Vertically Help. I am trying to center te. | Excel Discussion (Misc queries) |