How to Change the Default Setting of Alignment

Anonymous
2020-04-05T11:34:35+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. Anonymous
    2020-04-07T12:23:05+00:00

    OK. Anyway, thanks for your reply~

    2 people found this answer helpful.
    0 comments No comments