Change the Default Cell Alignment in Excel 2016
Question details
The user wants new Excel 2016 workbooks and worksheets to use a preferred cell alignment by default.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows
- Scenario
- Create new workbooks and worksheets with centered horizontal alignment and top vertical alignment.
- Observed behavior
- New files and sheets should use the chosen alignment without requiring the user to format cells each time.
Decide which horizontal and vertical alignment you want for new cells. Locate your Excel startup folder by entering %appdata%\Microsoft\Excel\XLSTART in the File Explorer address bar; its location can vary by installation.
Create default workbook and worksheet templates
Use Book.xltx for new workbooks and Sheet.xltx for new worksheets.
In Excel 2016, select File > New > Blank workbook. Keep one worksheet in the workbook.
Click the Select All triangle at the upper-left corner of the worksheet, between the row and column headings. On the Home tab, open the Alignment dialog, set Horizontal to Center and Vertical to Top, and click OK.
Select File > Save As > Browse. Choose Excel Template (*.xltx) as the file type, navigate to the XLSTART folder, and save the file as Book.xltx.
With the formatted, single-sheet workbook open, select File > Save As > Browse again. Choose Excel Template (*.xltx) and save it in the same XLSTART folder as Sheet.xltx.
Close and reopen Excel, then press Ctrl+N to create a workbook. Add a worksheet with the plus button and check the alignment in both sheets.

Format Spreadsheet Alignment with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and adjust cell alignment as you migrate your work.

Frequently Asked Questions
What is the difference between Book.xltx and Sheet.xltx?
Book.xltx supplies the starting format for a new workbook. Sheet.xltx supplies the starting format for a worksheet added to a workbook.
Where is the XLSTART folder in Excel 2016?
On Windows, enter %appdata%\Microsoft\Excel\XLSTART in the File Explorer address bar. The active startup folder can vary by installation.
Will these templates change alignment in existing worksheets?
No. To change an existing worksheet, select the cells you want to update and use the alignment controls on the Home tab.
Can I use a different alignment in the templates?
Yes. When formatting the selected worksheet cells, open the Home tab's Alignment dialog and choose the horizontal and vertical settings you prefer before saving the templates.




