Yesterday I showed you how to darken the grid lines in an Excel worksheet. (click here to read that tip.)  If you want to keep those changes, or any other changes you prefer, for all of your new worksheets, you’ll need to create a new default template. Here’s how:

Open the worksheet or create a new one and make all of your preferred changes.

excel-darker-square

Click the File tab at the top left.

excel-file

Select Save As.

choose-save-as.jpg

Name the file Book and for file type choose either Excel Template (.xltx) or Excel Macro-Enabled Workbook (.xlsm) depending on which you need.

excel-template-save.jpg

You’ll now need to save this template in the startup folder.  To find out what the particular path is to the Start Folder on your version of Excel, you’ll need to go back to Options and open Trust Center.  Click on Trust Center Settings.

excel-trust-center.jpg

You’ll want to click on the Excel Startup and verify the path to Excel’s start-up folder. This could vary depending on your device and your version of Excel. Make sure to check.

excel-trust-center-start-path.jpg

Select Save As on the template we created and start following that path. Here, we’ll follow the path on my PC. It’ll be different on yours. Here’s my path: C:\Users\Editor\AppData\Roaming\Microsoft\Excel\XLSTART\

So I’ll browse for a spot to save the template and start with the C Drive.

excel-trust-center-start-path-c-drive.jpg

Click the arrow next to it and choose Users. Then I’ll select my username of Editor.

excel-trust-center-start-path-users.jpg

Followed by App Data.

excel-trust-center-start-app-data.jpg

Then Roaming.

excel-trust-center-start-app-data-roaming.jpg

Then Microsoft. Hang in there. We’re almost there.

excel-trust-center-start-app-data-roaming-microsoft.jpg

Now, select Excel.

excel-trust-center-start-app-data-roaming-microsoft-excel.jpg

Then XLSTART.

xls-start.jpg

Now, you can hit Save to add your new startup template.

xls-start-save.jpg