Skip to main content
AmigoFish

Excel Defaults You'll Wish You'd Turned Off Years Ago (+Cheatsheet)

From MyOnlineTrainingHub · · 13 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Tired of Excel turning text into dates, resizing your columns, or AutoSaving changes you didn’t want? Here are 15 default settings you should turn off today. ⬇️ Download the cheatsheet and the example file here: https://bit.ly/defaults26file 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/defaults26course

Most of Excel’s default settings are designed for general use, but in daily work, they often get in the way. In this tutorial, we walk through 15 settings to change once so your spreadsheets stay clean, predictable, and frustration-free.

What we cover: • How to stop Excel from guessing dates and changing your text. • Cleaning up PivotTable defaults (tabular layout, fixed column widths, date grouping). • Turning off unhelpful formula prompts and Copilot popups. • Disabling AutoSave to keep test files safe. • Setting up your preferred font, layout, and startup view.

LEARN MORE ===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS ============== 0:00 Fix these before Excel annoys you 0:30 Stop turning text into dates 1:51 Turn off those green corner triangles 02:42 Pick your own default font 03:46 Hide the gridlines 04:21 Normal cell references instead of table names 05:06 AutoSave saving when you didn’t want it to 06:15 Better default layout for PivotTables 07:20 Stop columns resizing every time you refresh 08:05 Stop grouping dates automatically 08:30 Copying multiple things at once 10:01 Open straight to a blank workbook 10:32 Stop opening links in Excel for Web 11:08 Turn off Copilot formula popups 11:49 Make the top search bar smaller 12:24 Show file extensions (.xlsx) 13:20 Tricks you wish you'd learned sooner

#Excel #ExcelSettings #ExcelTutorial

Back to MyOnlineTrainingHub · Report a problem