Office Settings & Configuration

Change the Default Cell Alignment in Excel 2016

Tauseeq MagsiTauseeq Magsi Nov 20, 2026 869 views

Question details

The user wants new Excel 2016 workbooks and worksheets to use a preferred cell alignment by default.

Change the Default Cell Alignment in Excel 2016
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.
Before you start

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.

Solution 1Recommended

Create default workbook and worksheet templates

Use Book.xltx for new workbooks and Sheet.xltx for new worksheets.

1
Create a workbook

In Excel 2016, select File > New > Blank workbook. Keep one worksheet in the workbook.

2
Set the alignment

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.

3
Save the workbook template

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.

4
Save the worksheet template

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.

5
Test the templates

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.

Create default workbook and worksheet templates
Existing files are unchanged: These templates affect new workbooks and worksheets, not cells already present in existing files. If the templates are not applied, check their names and confirm that they are in Excel's active XLSTART folder.
Free Microsoft Office alternative

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.

Adjust horizontal and vertical cell alignment in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesWork in a familiar, easy-to-use interfaceUse a lightweight office suite with a free version
microsoft office alternative - wps office

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.