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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920