Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 not entering previously entered text automatically

23 Jan 2011   #1
tex50

Windows 7 Ultimate x64
 
 
Excel 2010 not entering previously entered text automatically

Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn it on always. Hope this is clear enough. Help appreciated.


My System SpecsSystem Spec
.
23 Jan 2011   #2
r3plicat3

Windows 7 Ultimate x64
 
 

Quote   Quote: Originally Posted by tex50 View Post
Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn it on always. Hope this is clear enough. Help appreciated.
Can you post a screenshot of what it looks like when it duplicates correctly?
My System SpecsSystem Spec
23 Jan 2011   #3
tex50

Windows 7 Ultimate x64
 
 

Quote   Quote: Originally Posted by r3plicat3 View Post
Quote   Quote: Originally Posted by tex50 View Post
Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn it on always. Hope this is clear enough. Help appreciated.
Can you post a screenshot of what it looks like when it duplicates correctly?
Its just a duplicate of what I typed earlier filled in automatically after I enter a couple of letters.
My System SpecsSystem Spec
.

24 Jan 2011   #4
mikedl

Windows 7 Ultimate x64 SP1
 
 

Hi, tex50, welcome to the Seven Forums!

Go to the "File" tab and the click on "Options":

Excel 2010 not entering previously entered text automatically-screenshot00469.jpg

Then check this setting in the "Advanced" options section of Excel 2010:

Excel 2010 not entering previously entered text automatically-screenshot00468.jpg


My System SpecsSystem Spec
Reply

 Excel 2010 not entering previously entered text automatically




Thread Tools




Similar help and support threads
Thread Forum
Text and numbers are shown as General in excel 2010
Hello, When I enter a text into a cell, say "Programming" or a number, say "12.543", Excel shows each one as general instead of a text or number! Why please? What text or number I need to enter into a cell that Excel shows and treats it as number or text?
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Make Excel 2010 Automatically Organize by Column "A" with Header
Hi all, I'm working on an excel spreadsheet for my passwords. My columns are labeled website, username and password, respectively. I know how to go to data>sort to sort what I have so far, but is there a way for me to be able to put a new website, username and password at the bottom of the list,...
Microsoft Office
Cursor randomly jumps to previously entered lines while typing
hello all whenever I'm typing a text on this laptop (Fujitsu Siemens Amilo Li 1818) the cursor (http://img7.imageshack.us/img7/4272/cur1w.png) changes it's position randomly i.e. to: http://img508.imageshack.us/img508/8369/cur2.png. It is very frustrating as I need to put the cursor back in...
General Discussion
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Clipboard or Macro for text entering?
Does anyone know of any MACRO clipboard type utilities for Windows 7? Im looking to type in certain phrases and when i type rv1 or something it will paste a line of text I previously entered for rv1? on MAC I use typinator but Im unbale to find anything on windows 7 like this. Any help...
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 16:42.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App