How to Change the Default Setting of Alignment

Question

I think there are default settings of alignment, for example:

The text in a cell is originally aligned at the center.

Click "Top Align" button will set the text aligned to the top.

Click "Top Align" button AGAIN will automatically set the text aligned to the bottom (Office 365 for Business version 2003 Monthly Channel)

It seems like that:

Click the alignment setting button once means this setting is "ON".

Click the same button again means this setting is "OFF" and the default setting will automatically be "ON".

As I remember, for Excel 2016, the default alignment setting is "Horizontal General + Vertical Center", but now in Excel 365 the default setting is "Horizontal General + Vertical Bottom".

How to Change the default setting of alignment?

P.S. I know that using book.xltx and sheet.xltx in folder XLSTART can change the initial alignment settings for new workbook and sheet, but this is not what I am looking for.

Answer 1

The default setting (at least in Excel for Windows) has always been Horizontal: General and Vertical: Bottom.

There is no way to change these settings at the application level. They are hard-coded.

If you don't want to use default templates Book.xltx and Sheet.xltx, you can change the default for a specific workbook by modifying the Normal style:

Answer 2

Hi Eli Xu,

Honestly, there is no option for users to set default vertical alignment, but I think it is possible to use VBA code to change alignment automatically.

Please check this article and see if helps.  

If you need more help about VBA code, I kindly suggest you creating a new thread in Programming category where is  dedicated to related queries.

Thanks for your understanding.

Regards,

Eric 

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

Answer 3

Thanks for your reply~

Well, just check again and at least Excel 2016 (16.0.4939.1000) uses Vertical Center as default setting. It is my company's laptop and I am not sure that IT colleagues of my company have done any customized settings or not.

And using templates or normal style can only change the INITIAL settings, not the default settings. 

Is it possible to set default alignment by changing registry? I will do it at my own risk ;-D

Answer 4

Thanks for your reply~

Well, is it possible to set default alignment by changing registry? I will do it at my own risk ;-D

Excel 2016 (16.0.4939.1000) on my company's laptop is using Vertical Center as default setting, and I am used to this.

Answer 5

Sorry for late response.

While I didn't find any register setting to explicitly change the cell alignment.

You can post your requirement to UserVoice where is your place to suggest ideas or vote for ideas for improving the Excel.

Thank you for sharing your issue and requirement with us. We listen to all feedback and consider them for additional feature/future versions of our products. Your feedback helps us know which features are most important to you. We appreciate your continued interest in Microsoft products and services. Microsoft is committed to continuously improving your experience with our products.

Regards,

Eric