Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

How Do I Turn Off Auto Correct?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I need help with auto correct.

View Answers     

Similar Excel Tutorials

How to use Vlookup Across Multiple Worksheets in Excel
This tutorial shows you how to use the Vlookup function across multiple worksheets within Excel.  This means that y ...
How to Resize Rows and Columns in Excel Quickly
Resizing rows and columns in Excel is an easy process. Simply left click in between the columns and drag the mouse ...
How to Make Macros Run A LOT Faster
Here is a very simple and easy-to-use tip to make all of your Excel macros run A LOT faster.  It is very simple and ...
Stop Formula Calculation in Excel - Increase Worksheet Performance
I'll show you how to stop formulas and functions from performing their calculations and updating in Excel. This ma ...

Helpful Excel Macros

Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a
Basic Web Query in Excel - Import Data from the Web into Excel
- Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any web
Bubble Sort
- This macro will perform a bubble sort in excel. You use it simply by selecting one column to sort and then running the
Format Cells as a Percentage in Excel Number Formatting
- This free Excel macro formats a selection of cells as a Percentage in Excel. This simply changes a cell's number format
Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
- Automatically run an Excel macro at a certain time. This allows you to not have to worry about running a macro every da

Similar Topics

am having a problem getting correct results with my vba code. How would you construct correct vba code to produce
correct unique values at the bottom of the table ?
A B C D E Description Category Date Trans type Amt. Apples 11/15/11 Auto. $10 Oranges 11/16/11 Auto. $20 Pears 11/16/11 Auto. $30 Apples 11/18/11 Auto. $40 Pears 11/19/11 Auto. $50 Oranges 11/20/11 Auto. $60 Should give Apples $50 Oranges $80 Pears $80

I'm working on a time sheet, and to make it easier to enter time i created a macro that sets the auto correct to correct a "." to a ":", but when the workbook closes i want to run a macro that deletes the auto correct rule. how do i do that?

Is there somewhere I can edit the AutoCorrect Data in an easier way that
using the Auto Correct options menu. I want to input a large amount of data.
Is there a master list or sheet somewhere?


Does anyone kno if i can turn off the auto correct for dates. I never type the date as 23-4-11 always with a / so I have no need for Excel to automatically convert the format of the cell to a date. I use - for other things and always have to format the cells as text first. Very annoying!

where is the auto correct data file stored?
I have ust set up a new pc and need to transfer the info

I am using Office 2007, and I figured out how to turn off the autocorrect function in Word, but I can't find the function in Excel.

Any help will be greatly appreciated

I am trying to use the auto sum feature, when I try to add multiple auto sums
together,, it returns a zero total. what do I need to turn on or off to so I
can get the correct total

Hi All

I need help with a formula that will scan down a list of names in column A and compare it to a list in a hidden column (D).The idea is that it will check the spelling in column A and auto correct it to the one in D.

I will use this when i am downloading data to excel as there can be variencies in spelling e.g. Absence or Absense. My existing macro's which are auto populating another workbook just ignore the spelling mistakes, which then means that the auto populated data is wrong and there are far too many entries to individually correct each mistake.


Please can you give me a solution to my problem.

I have a Table in Excel 2010 and in one column I have a formula. During the year the formula changed . So for example from row 1 to 500 I had my original formula, which must stay, but now I have changed the formula from row 501 onwards.

What my problem is , everytime I add a new row to the Table the formula auto updates buts takes the old formula from Row1 and I have to manually copy my new formula over the old one.

Just for THIS column I do not want excel to Auto correct or update. But for the rest of the table it must keep auto update.

I do not want to cancel the Proofing in the Options , because that will apply to all my spredsheets and files.

Any ideas what can I do.

I am trying to type the intials for a company which are CNA. Every time I do this, Excel auto corrects to word to CAN. How do I get around this problem.

I am working w/ values that are interpreted as dates by Excel. The issue is that as I change it through code and have it displayed as I need it, I have to move it around to other locations w/in current sheet or to other sheets it gets reformatted to a date or serial number.

I was looking for a way to disable this feature as akin to turning off auto-correct feature. But have not found any method to do so. Can this be done in code?



I know how to turn off auto-expansion by
"unchecking the Include new rows and columns in list option on the AutoFormat As You Type tab of the AutoCorrect dialog box."

how do you turn it back on?

Thank You!

I am constantly running into this horrible design decision to auto-check
excel formulas as they are typed. I type in formulas, then add parentheses
from the right hand side back to the left to make certain of the calculation
orders. Every time I put in a close paren and then move backwards to add the
opening paren, Excel interrupts me and pops up a dialog telling me my formula
is broken..... WHILE I AM STILL TYPING IT. The worst part is that it
requires two clicks of non-default options that alternate positions (i.e. I
have to move the mouse t the correct button two separate times) in order to
go back to typing my formula. I have turned off every auto-check option
there is, and it still does this. GIVE ME A WAY TO TURN THIS OFF!


I run a football sweep in work, and I currently have a Leaderboard with 16 players in it.

The Cell Headers are
Position; Name; Correct Results; Correct Scores; Total Points

The leaderboard is set by the Total Points, then the number of correct results, then the number of correct scores. My Total Points auto populates from the monthly tabs I have, and each persons score for that month. However I would like the cells to Auto Sort based on the Total Points, but to keep the other cells tied in with the Points Except from the position colum.

Is anyone able to help me do this. So if someones points put them from 4th to 1st, then the name cell, correct results, scores, and points cell all go with them.

I have attached an image to give you an idea of what I mean

Thanks in Advance


i use excel 2003. have just noticed that on several of my worksheets the auto sum works but only after i have hit save. until i save any changes to the set of numbers in the auto sum do not reflect in the total. only when i hit save does the sum total adjust to the new correct number. This problem is just on the last few worksheets that i have created. On all my other worksheets the Auto SUM works correctly, showing the new total as soon as a new number is entered in the auto SUM column.

What line of code would I need to used to turn off the auto-calc upon opening a workbook?


I am trying to set up a new auto run macro that will run automatically when a workbook opens.

What is the correct macro name to do this that is compatable with excel 2003 and 2007?

In this auto run macro, I would like to tell the system to alway run a macro by the name of Every_update anytime there is an entry made anywhere in the entire workbook. What is the best way to do this?

I've been working with a large, old spreadsheet that I inherited. It has
~150 worksheets.

Occassionally, a row of formula won't update. That is, I change some values
on 1 worksheet, but when I get to another, the new values are not reflected
in a formula that might be merely adding 2 cells from the first sheet. I
have and keep auto calc = "on". I can go to the cell and hit "F9". The
value doesn't change.

If I re-type the exact formula, it correctly calculates and shows the
correct value. If I drag and auto fill this formual across the row,
essentially replacing each formula with an exact duplicate of what it already
had, the value re-calculate and display the correct value.

What could cause this? More importantly, how do I fix it?

Thank you, in advance for any suggestions.

I am using a simple excel credit/debit worksheet that is auto totaling in the last column. I have 5 or 6 entries a year and I would like to leave a blank row between years for grouping. When I leave a blank row the auto total function doesn't work, is there any way to correct this? My curent formula is:


When I open a new instance of Excel 2007, Auto-calculate is set to ON. I then turn this option off, close Excel only to find that upon re-opening Excel, Auto-calculate is again set to ON. Strangely, when I make this modification in a fresh instance of Excel 2007, I am asked to save the workbook, 'Book1.xls'.

Seems like there is a file or a setting somewhere on the system that needs to be modified to allow me to turn off Auto-calculate. Where can I find this file/setting?

O/S: XP Professional SP2


- Luis

I am trying to enter =MT4|BID!6EU8
and excel 2007 keeps trying to auto correct and i cant over ride it
6EU8 is a stock ticker symbol

Attached is a file I'm having trouble with. I need to figure out a way to sort criteria in 3 columns by formula or vba, since sorting ascending/descending doesn't work with these bond ratings, and I can't figure out a formula that works.
I've Added a (Triple A?) column to show what the formula or vba code should evaluate to.
If blanks are present in Columns B, C, or D...its ok. For each range of cells (B:D) in each row... If any other value other than "Aaa", or "AAA" are present, then it is NOT "triple A". I highlighted the rows in RED that appear to be ok, but really are not ok, because one of the values is not Aaa or AAA.

sMatrix MDY SP Fitch Triple A ? AUTO A2 A

Please Help!


I've searched through previous post with no luck on my workbook. I would like to have all the auto filters remain active all the time.

I have workbooks with a dozen or so worksheets, each having their own auto filters set. When I protect the sheet, I select to allow filter use and it works. But when I reOpen the workbook the fitlers don't work. I have to unprotect and protect again saying to allow filters. I have to do this on every sheet I want to use.

Can there be a way of 'on open' or 'auto-run' something to turn all the filters back on when anyone opens the file?

Thanks, I appreciate any suggestions and help.
In Atlanta

Hello all,
How do I auto fill a series of 2014 dates in the row below the weekdays? I have a row C5 that has a series of auto fill weekdays successfully for 2014. I can't seem to auto fill the weekdates in the row below. I have to make manual adjustments for each Monday, and for the correct month ends, etc.
Do you have a solution for me?
Thank you.

Lately, I've been having problems with the Auto Filter feature. Previously it worked fine, but now it will just not filter on a couple of my spreadsheets.

Some background: The spreadsheets in question have around 200 lines. I am using Excel 2003 on Windows XP Pro and consider myself fairly proficient at Excel.

Here's what tends to happen: With Auto Filter on, a few filters may work, but eventually, I will click the down arrow to make a selection and nothing happens. To fix the problem, I have to turn off the Auto-Filter and then usually, have to select all rows and Unhide everything to show all the data. Then, I will turn Auto-Filter back on and the same process will start all over again.

This only started to happen recently and as far as I can tell only on a couple of similar spreadsheets with data in approx. 20 columns with a few VLOOKUPs in the data.

Any thoughts or suggestions?