Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Taffy
 
Posts: n/a
Default select the first cell in the next row down after pressing enter o.

How can i select the first cell in the next row down after pressing enter or
tab?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Taffy

With ToolsOptionsEditMove after enter set to "down".

Start in A1, work your way across to J1 using the TAB key to leave each
cell after typing in your data.

Leave J1 by hitting the ENTER key to go to A2.

Another way.........

Unlock columns A through J and protect the worksheet.

TAB your way across to J1 then next TAB will take you to A2.


Gord Dibben Excel MVP

On Tue, 1 Mar 2005 08:03:04 -0800, "Taffy"
wrote:

How can i select the first cell in the next row down after pressing enter or
tab?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Help...How can I do this? Select a cell zoombr Excel Worksheet Functions 1 March 23rd 05 08:34 PM
Mouse continues to select after clicking on a cell in excel. Fletch Excel Discussion (Misc queries) 4 February 22nd 05 02:27 AM
Select part of a cell Joe Excel Worksheet Functions 6 February 16th 05 06:21 PM
Create a drop down in XL cell to select date Steveterrigal Excel Worksheet Functions 1 December 30th 04 03:09 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"