ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I keep cell (after I put data in it) from going down automa (https://www.excelbanter.com/excel-discussion-misc-queries/130400-how-do-i-keep-cell-after-i-put-data-going-down-automa.html)

bojoco

how do I keep cell (after I put data in it) from going down automa
 
I want to put data in both down and sideways. By default after I put data in
a cell, the next cell DOWN is always highlighted. How can I get it to remain
where it is, rather than automatically go down.














bpeltzer

how do I keep cell (after I put data in it) from going down automa
 
From the menu bar, Tools / Options, select the Edit tab and deselect 'Move
selection after Enter' (note you can also choose to move in another
direction).

"bojoco" wrote:

I want to put data in both down and sideways. By default after I put data in
a cell, the next cell DOWN is always highlighted. How can I get it to remain
where it is, rather than automatically go down.















All times are GMT +1. The time now is 12:22 AM.

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