Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 31st 06, 01:21 AM posted to microsoft.public.excel.misc
GregM
 
Posts: n/a
Default offset 1 row and return to first column

I have a worksheet which is used for inputting data in columns a through to
f. When the user has completed inputting all info and either enters or tabs
in the final column, is there a way to get excel to jump down to the next row
and go back to column a?

  #2   Report Post  
Old March 31st 06, 01:37 AM posted to microsoft.public.excel.misc
Nikki
 
Posts: n/a
Default offset 1 row and return to first column

unlock all the column A_F and locking column after F & protect worksheet . if
you type in f and click on tabs it will go to the next row column A.

Nikki

"GregM" wrote:

I have a worksheet which is used for inputting data in columns a through to
f. When the user has completed inputting all info and either enters or tabs
in the final column, is there a way to get excel to jump down to the next row
and go back to column a?



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



All times are GMT +1. The time now is 01:29 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017