View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default HOW DO I CREATE AN AUTO RETURN IN A COLUMN THAT IS OFF MY WORKSHEE

Linda

Start in column A and Tab your way to Column M.

When leaving Column M hit the ENTER key to go back to A and one row down.

Make sure your ENTER key is set to move down via ToolsOptionsEdit "Move
selection after enter"


Gord Dibben MS Excel MVP

On Tue, 15 Aug 2006 10:51:02 -0700, LINDA
wrote:

I HAVE TO ENTER DATA OVER AND OVER AGAIN IN A WORKSHEET. I CAN HIT THE TAB
BUTTON AND AUTOMATICALLY GO TO THE NEXT CELL. HOWEVER, WHEN I GET TO THE END
OF THE ROW I ENTERING I HAVE TO SCOLL BACK TO THE BEGINNING OF THE WORKSHEET
OR BACK TAB TO IT. IS THERE ANYWAY TO FORMAT THE COLUMN AT THE END OF MY
WORKSHEET THAT I DON'T NEED TO HAVE A "AUTO RETURN" FUNCTION THAT WILL SENT
MY CURSOR BACK TO COLUMN A. THAT WOULD BE SO WONDERFUL!!!!! THANKS.


Gord Dibben MS Excel MVP