I think I found a solution on another website so I will mark this as solved. Here is what I found, it seems to work for me:

How to change default page alignment on excel startup:
1. Change Default Alignment Settings
Hello there,

I have successfully been able to change the alignment settings in microsoft excel to the left and the top but I have to continue to do that for each cell or groups of cells in the excel document.

I wanted to know if there was a way that I would be able to change the default settings so that every time I open excel it always aligns to the top and the left (similar to page layout options in word).

Thanks to anyone that can help.

-BB
Register To Reply
2. 07-23-2019, 06:00 AM#2
Aardigspook

Forum Expert
Join Date
03-20-2015
Location
Primarily UK, sometimes NL (COVID allowing)
MS-Off Ver
Work: Office 365 / Home: Office 2010
Posts
2,402
Re: Change Default Alignment Settings
Welcome to the forum.

You can do this by creating a template which has your preferred options set.

1. Open a blank workbook.
2. On the 'Home' tab, in the 'Styles' section, right-click on the 'Normal' style. Set the options the way you want.
3. Save the file as an 'Excel template (*.xltx)' and call it 'Book.xltx'. Don't close it yet.
4. Now save the file again, this time as 'Sheet.xltx'.
5. You need to put these two files into your XLstart folder. To find it, copy and paste this into the address bar of File Explorer: %appdata%\microsoft\excel\xlstart
(It's a hidden folder, so you may need to enable viewing hidden folders first.)
6. Copy the two files you just made into this folder.

Book.xltx will now be used whenever you open a new file.
Sheet.xltx will be used whenever you add a new sheet.


In step 2, you can set any other options you like, such as the theme (to set default fonts), margins and so on.


I've seen some reports that in newer versions of Excel, it won't use 'Book' if you just click 'blank workbook' from the start screen. To get it to use your now-perfect 'Book' you first have to disable the start screen by going to 'File' → 'Options' → 'General' → 'Start up options' and then un-select 'Show the start screen when this application starts'. I haven't had this problem myself (I use 2010) but I include the info just in case.


Hope that helps.