I've used MS Office for Windows in the past and am new to the Mac program. I'm working on a large data spreadsheet. There are a lot of cells with repeat information (city/state). When the program makes a suggestion based on an entry previously typed, I hit enter to have it automatically fill in the cell. The program is then advancing to the next cell down in the column rather than the next cell in the row. Does anyone know how to change that? Thanks!
Excel 2008 Automatic Data Fill
- Thread starter BEL18
- Start date
- Joined
- May 12, 2011
- Messages
- 79
- Reaction score
- 3
- Points
- 8
- Location
- China
- Your Mac's Specs
- Mac OSX 10.7.3: MBP 15" Early 2011 2.0GHz i7, 8GB, 500GB 5400RPM
Hi,
In Excel (I use 2011 but hope it is the same), go to Preferences, go to 'Authoring' and select 'Edit'.
Third box down on the left should be checked and the default is set to 'down'. Pick your preferred direction and click OK.
Hope it works!
In Excel (I use 2011 but hope it is the same), go to Preferences, go to 'Authoring' and select 'Edit'.
Third box down on the left should be checked and the default is set to 'down'. Pick your preferred direction and click OK.
Hope it works!
Shop Amazon
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.