Stop Tables from Auto-Filling Formulas Down in Excel

Add to Favorites
Author: | Edits: don

Two simple ways to stop Tables from auto-filling formulas in new columns.

Auto-filling formuals in Tables can be nice or terribly annoying, but now you will learn how to control this feature.

Steps Method 1 - Quick But Temporary

Ctrl + Z after inputting the formula in the column.

Steps Method 2 - Long Lasting

File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type tab > uncheck Fill formulas in tables to create calculated columns.

 


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Similar Content on TeachExcel
Stop Formula Calculation in Excel - Increase Worksheet Performance
Tutorial: I'll show you how to stop formulas and functions from performing their calculations and u...
Pause a Macro or Make it Slow Down in Excel
Tutorial: How to make a macro stop or pause for a specified amount of time. This allows you to slow ...
Elegant Date and Location Filtering in Excel - A Must See!
Tutorial: Visually nice way to add Date and Location Filters in Excel. This combines Tables with Sl...
Update, Change, and Manage the Data Used in a Chart in Excel
Tutorial: In this tutorial I am going to show you how to update, change and manage the data used by ...
Highlight Every Other Row in a Selection in Excel - Table Formatting
Macro: This free Excel macro will highlight every other row in a selection of cells with a color ...
3 Methods to Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all space...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)