ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is there a keyboard shortcut to center data in a cell? (https://www.excelbanter.com/excel-worksheet-functions/22199-there-keyboard-shortcut-center-data-cell.html)

Phil_K

Is there a keyboard shortcut to center data in a cell?
 
I was wondering if there is a keyboard shortcut for the button on the format
toolbar for centering data in a cell. Any help is appreciated.

David McRitchie

Hi Phil,
You would have to create a macro and assign your own button

Creating a Center Across Selection Button (this is the code)
http://exceltips.vitalnews.com/Pages..._Button.ht ml
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Phil_K" wrote in message ...
I was wondering if there is a keyboard shortcut for the button on the format
toolbar for centering data in a cell. Any help is appreciated.





All times are GMT +1. The time now is 03:11 PM.

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