Excel Shortcut - Ctrl+N to Use Defaults for new Excel Workbook - Episode 2148

2,033 views · Published 7 September 2017 · 1:15 · Indexed 23 October 2026

Channel: MrExcel.com · 2017 · Education

Watch on YouTube

Microsoft Excel Tutorial: Creating a new workbook with your favorite settings.
Ctrl+N will inherit settings from your book.xltx file.
But File, New will not.

Welcome to another episode of Learn Excel From MrExcel. In this episode, we will be discussing the CTRL+N shortcut for creating a new workbook in Excel. Now, you may be thinking, "What's the big deal? I can just go to File, New and create a new workbook." But let me tell you, using CTRL+N is a game changer.

When you use CTRL+N, it not only creates a new workbook, but it also inherits your favorite settings from book.exceltx. This means that if you have certain column widths, margins, or header/footer settings saved in book.exceltx, they will automatically be applied to your new workbook when you use CTRL+N. This saves you time and ensures consistency in your workbooks.

But what if you don't know how to set up book.exceltx? Don't worry, I've got you covered. In the top right-hand corner, you will see an "i" icon. Click on that and it will take you to a podcast where I show you how to set up book.exceltx. Trust me, it's worth it.

So next time you need to create a new workbook, remember to use the CTRL+N shortcut. It will not only save you time, but also ensure that your favorite settings are applied. Thanks for watching and don't forget to subscribe for more Excel tips and tricks from MrExcel. See you in the next episode!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#excel
#microsoftexcel
#exceltips
#excelshortcut
#evergreen
#shortcutkey

This video answers these common search terms:
change default font in microsoft excel
how to change default font excel
how t change the default font in excel
how do i change the default font in excel
how to change permanently the default font in excell
change default in excel
how to change default settings in excel
how to change default settings in ms excel
how to change default background color in excel
how to change default zoom in excel
how to change default borders colour  on excel
how to change default in excel
how to change default text in excel
how to default settings on excel
how to set default excel
how to set default in excel
how to set default margins in excel
how to set default text in excel
how to set default width & height on excel
what is the default alignment in excel
what is the default column width in excel

Table of Contents:
(00:00) Introduction to Episode 2148: CONTROL+N for New Workbook
(00:11) Inheriting favorite settings from book.xltx
(00:21) Example of favorite settings being applied
(00:34) Difference between using CONTROL+N and FILE, NEW
(00:45) Importance of using CONTROL+N for new workbooks
(00:55) Link to tutorial on setting up book.xltx
(01:05) Clicking Like really helps the algorithm

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153973/

More from this channel