View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Return to Home Row

One method.

Select columns A to G and unlock them.

Protect the sheet with "select locked cells" disabled.

Arrow across from A1:G1. When leaving G1 you will drop to A2


Gord Dibben MS Excel MVP

On Mon, 29 Dec 2008 07:47:01 -0800, Jeff
wrote:

Is there an option which would allow me to return to my 'Home Row' when I hit
the Return key? It functions that way when I tab from column to column, but
not when I arrow from column to column.

Thanks!