Changing default cell alignment in Excel

Changing default cell alignment in Excel

There are lots of different users who are also complaining they can’t change the default cell alignments of Microsoft Office Excel and wanting to change them but there’s no way of changing them no matter how hard they try. I think the reason for this is because they only rely on the buttons available in the application.

Even if it may sound impossible to change, there is still a way of modifying the default cell alignments of the application and this is by creating your own template and automatically using it each time you use Microsoft Office Excel. Here’s how. If Microsoft Office Excel is already running, close it and then open it again to make sure you are using a fresh sheet.

Then create a blank workbook. Format everything the way you want it like set the vertical alignment to Middle Align, the horizontal alignment to Center, and so on. See image.

Save it as Excel Template and name it as “Book.xltx”. Click the Office Button then select Save As or simply press F12. In “Save as type”, select “Excel Template (*.xltx)”. See image.

Copy it in “C:Documents and Settings[username]Application DataMicrosoftExcelXLSTART”. To view this folder enable “Show hidden files and folders” in the Folder Options of Windows Explorer. This will be used when creating a new blank workbook. Create a copy of the file containing only one sheet and save it also as an Excel Template in the same folder. Name it as “Sheet.xltx”.

This will be used when inserting a new sheet.