ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Move cursor 5 rows down (https://www.excelbanter.com/excel-discussion-misc-queries/204115-move-cursor-5-rows-down.html)

Tracy

Move cursor 5 rows down
 
How do I get the cursor to jump 5 rows down each time after inputting data?
--
Tracy

Jim Thomlinson

Move cursor 5 rows down
 
There is no built in way of doing that. You could use a macro to do that but
you need to determine the criteria for moving down 5 lines. What tells the
system that the data input is complete. Do all of the cells in the row need
to be filled in? Does only 1 cell need to be filled in? Is this a feature
that you want your users to be able to enable and disable as necessary?
--
HTH...

Jim Thomlinson


"Tracy" wrote:

How do I get the cursor to jump 5 rows down each time after inputting data?
--
Tracy



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com