ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change entries from automatically going dwn row to across in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/211858-change-entries-automatically-going-dwn-row-across-excel.html)

Sunshine

Change entries from automatically going dwn row to across in Excel
 
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

OssieMac

Change entries from automatically going dwn row to across in Excel
 
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


John[_22_]

Change entries from automatically going dwn row to across in Excel
 
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" wrote in message
...
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




All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com