Page 1 of 1

Spreadsheet Redundancy Function

PostPosted: Fri Apr 22, 2011 7:23 am
by RexinMinn
Entering data into a spreadsheet in Numbers can certainly be a devilish proposition. The reason is because of its automatic redundancy function. What this does is repeats, or makes redundant, any entry you've previously made when you try to enter an alphaic value into a new cell. For example, if you type "July 30" into a new cell, and then you enter it, Numbers will remember this entry for the next time you type anything beginning with the letter "J" which is annoying as hell. So you want to type July 31 into the cell, it will automatically enter July 30 for you first, which is NOT what you want, forcing you to check the screen to make sure you've corrected what it entered. Not sure what they call this but I wish to turn this function OFF. Is it possible to turn off this redundancy function? Not sure what it may have been originally intended to do, but it's making my data entry job more difficult, adding many keystrokes and causing my eyes to become strained.

Re: Spreadsheet Redundancy Function

PostPosted: Tue May 10, 2011 1:46 am
by Barry
Hi Rex,

Numbers > Preferences > General...Editing
Uncheck "Show auto-completion list in table columns"

Regards,
Barry