Hi, I am just starting to use numbers. I used excel previously. I like a lot of things that numbers does, but the autofill is driving me crazy.
Turn on AutoComplete. On the Excel menu, click Preferences. Under Formulas and Lists, click AutoComplete. Select the Show AutoComplete options for functions and named ranges check box.
I am a researcher and I need to type in data. The top line of my sheet is the condition (ex. When I go to enter the data (whether a 3 or a 6 was picked) it autofills to either 6-3 or 3-6. The autofill content is longer than the content I want to type in, so I end up having to delete the extra digits from each cell by hand.
Is there anyway to either turn off autofill or tell it not to autofill certain cells? Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only.
Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.