Why Does Excel Default to Bottom Alignment

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
1,852
Office Version
2016
Platform
Windows
As per the title - does anyone have a convincing reason why the default cell alignment (text, number, whatever) is 'Bottom' - its perhaps the most annoying feature of this amazing product - and tedious to change on every spreadsheet I create or use. Tables in Word are Top aligned by default, why is Excel different?

I know how to change the alignment, but its a nuisance that it isn't a default setting.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,063
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
If it's that annoying for you, you could just change the Normal style in a workbook and save it as your Book.xltx template in the xlstart folder?
 

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
1,852
Office Version
2016
Platform
Windows
I have done that - following you're advice - so thank you (I'd tried before and for some reason always got it wrong!).

That still doesn't answer why Excel's authors prefer Bottom to Top, I've never found anyone who likes that arrangement - but found plenty who simply put up with it because they don't know any different and that isn't a justification.

Thanks for the feedback though.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,063
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Conversely, I like it and have never encountered anyone who had an issue with it, until now. :)
 

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
1,852
Office Version
2016
Platform
Windows
I guess the only thing I can say to that is 'isn't it a good job we're all different!' (though clearly you're wrong :))
 

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,016
Office Version
2016
Platform
Windows
I guess the only thing I can say to that is 'isn't it a good job we're all different!' (though clearly you're wrong :))
You're both wrong! Centre alignment is the way to go.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,024
Messages
5,472,082
Members
406,800
Latest member
TeachMeExcelPlease

This Week's Hot Topics

Top