Change entries from automatically going dwn row to across in Excel

  • Thread starter Thread starter Sunshine
  • Start date Start date
S

Sunshine

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split cells across multiple columns 1
Press Enter and Move Back to Column A Automatically 3
When a cell is selected, move to a different cell 1
switch rows and column data 2
Pivot table data layout - columns to rows 1
Excel Help to copy information from one row at a time to another sheet 1
Auto Fill Cell 1
Eliminating unwanted columns and eEntering data using Barcode Scan 2

Back
Top