Complete a row of text based on preexisting data in a worksheet
Posted on 2011-03-03
Hi. We recently upgraded from office 2000 to office 2010. One of my users adds rows of data to an existing spreadsheet on a daily basis. She claims that before we upgraded there was some sort of extended autocomplete functionality. She would start typing in data and if it matched data from a previous cell in that column, the entire row would get filled in to match the row it was drawing from once she hit enter.
As far as I know, autocomplete doesn't work that way. Does this functionality exist in excel 2010?