Ctrl-N. How to change the blank page ?

%3CLINGO-SUB%20id%3D%22lingo-sub-2789247%22%20slang%3D%22en-US%22%3ECtrl-N.%20How%20to%20change%20the%20blank%20page%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2789247%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELove%20Ctrl-N%20command%20which%20opens%20a%20default%20blank%20page.%3C%2FP%3E%3CP%3EBUT%2C%20I'm%20trying%20to%20find%20how%20i%20can%20permanently%20change%20that%20default%20blank%20page%20to%20a%20page%20I%20have%20formatted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%26nbsp%3B%20this%20is%20NOT%20an%20XL%20startup%20question.%26nbsp%3B%26nbsp%3BThis%20is%20ONCE%20Excel%20is%20already%20up%20and%20running%2C%20and%20I%20hit%20'Ctrl'-N'.%26nbsp%3B%20I%20want%20to%20change%20that%20blank%20page%20that%20opens%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20out%20there%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3ESuzanne%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2789247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi,

 

Love Ctrl-N command which opens a default blank page.

BUT, I'm trying to find how i can permanently change that default blank page to a page I have formatted.

 

Note:  this is NOT an XL startup question.  This is ONCE Excel is already up and running, and I hit 'Ctrl'-N'.  I want to change that blank page that opens up.

 

Any ideas out there ?

 

Thank you

Suzanne

2 Replies

@SuzanneB1065

Yes, it is in fact related to XLSTART.

If you create a blank workbook with the formatting that you like, and save it as an Excel template named Book.xltx in your XLSTART folder (%appdata%\Microsoft\Excel\XLSTART), then Excel will use this template when you press Ctrl+N.

@Hans Vogelaar 

 

Thanks for getting back to me quickly.

 

I just set it up the way you described.  It opened my formatted xl at startup, but still does not open it at Ctrl-N.  At Ctrl-N, it still goes with the default xl workbook.

 

Any other thoughts?

I'm on MS Office 365 Apps for Business, Subscription Product.  If that helps at all.

Thank you

-S.