Excel 2008 Automatic Data Fill

BEL18 · BEL18 #1 (**permalink**)

04-08-2012, 08:44 AM

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!

Pigstick · Pigstick #2 (**permalink**)

04-09-2012, 09:40 PM

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!

BEL18 · BEL18 #3 (**permalink**)

04-09-2012, 09:53 PM

It did work! Thank you so much!!!

Pigstick #2 (permalink)
Member Since: May 12, 2011 Location: China Posts: 79 Mac Specs: Mac OSX 10.7.3: MBP 15" Early 2011 2.0GHz i7, 8GB, 500GB 5400RPM	04-09-2012, 09:40 PM 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! Last edited by Pigstick; 04-09-2012 at 09:43 PM. Reason: comment on version
	QUOTE Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Moving / Resizing Formatting Palette (Word / Excel 2008)	chgboyd	OS X - Apps and Games	0	08-12-2011 08:51 AM
excel 2008 = NO VBA :-(	j4ymf	Switcher Hangout	7	07-25-2009 12:40 AM
Mail to Excel data merge/macro?	Small giraffe	OS X - Apps and Games	1	01-29-2007 10:55 AM

Excel 2008 Automatic Data Fill

Internet Services

Web Development

Digital Marketing

Consumer Tech

BEL18 #1 (permalink)
Member Since: Oct 06, 2011 Posts: 8	04-08-2012, 08:44 AM 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!
	QUOTE Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)