Want to switch data entry from going down column to across column after
pressing Enter. Knew how to do in Excel 2003 but can't find place to change
in 2007

Click the big Microsoft button top left of Excel window.
Select Excel Options (towards bottom right of dialog box)
Cick Advanced in the left column.
It is up the top of the dialog box under Editing Options.
--
Regards,

OssieMac


"Sunshine" wrote:

> Want to switch data entry from going down column to across column after
> pressing Enter. Knew how to do in Excel 2003 but can't find place to change
> in 2007

Hi Sunshine
Have a look here for a interactive command reference guide
for Excel 2003 - 2007.
You can download it and have it on hand
http://www.microsoft.com/downloads/d...ng=en#Overview

HTH
John

"Sunshine" <(E-Mail Removed)> wrote in message
news:E233107B-EE0A-49E8-A141-(E-Mail Removed)...
> Want to switch data entry from going down column to across column after
> pressing Enter. Knew how to do in Excel 2003 but can't find place to
> change
> in 2007