LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Press enter to return to first column

The arrow won't work without the sheet being protected and the columns to
the right of last column entry being locked.

i.e. Unlock columns A:H

Lock all other columns.

Protect the sheet and the rightarrow wiil take you across row 1 then down to
A2


Gord

On Tue, 23 Sep 2008 16:56:01 -0700, Sarah
wrote:

Yes sort of
It works if I Tab from A1 to H1, (it will return to A2) but not if I arrow
across to H1. Is there a setting I can change so I can set both to return to
A next row down???


 
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
How do I press enter inside a cell? subway Excel Discussion (Misc queries) 4 April 2nd 23 07:12 PM
Macro to select cells in column enter data then press enter NP New Users to Excel 1 February 20th 08 04:21 PM
macros doesn't execute unless i go into cell and press enter. Emma Excel Discussion (Misc queries) 2 October 20th 06 05:12 PM
Is there a way to skip over fields when I press the ENTER key? Kay Excel Discussion (Misc queries) 3 June 20th 06 07:18 PM
When I Press the Enter Key Nothing happens. bigev Excel Discussion (Misc queries) 1 March 1st 06 03:05 PM


All times are GMT +1. The time now is 06:37 PM.

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

About Us

"It's about Microsoft Excel"