Spreadsheet Redundancy Function

This forum is a self-help system for the exchange of ideas among iWork users.

Spreadsheet Redundancy Function

Postby RexinMinn » Fri Apr 22, 2011 7:23 am

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.
Posts: 44
Joined: Sat Feb 07, 2009 8:09 am
Location: Mpls Area

Re: Spreadsheet Redundancy Function

Postby Barry » Tue May 10, 2011 1:46 am

Hi Rex,

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

Posts: 1390
Joined: Mon Sep 30, 2002 12:54 am
Location: 48°50' N 123° 30'W

Return to iWork Help

AppleWorks Users Group Logo iWork Users Group Logo