View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
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