I would like to know if there is any way to move between cells without moving into vacant cells between them. I have a set of worksheets in Excel that require a lot of data input, too much for a form, whereas each page is different. Its sort of like a huge questionaire. Since I have boxes on different rows and some on same but different columns, I'd like the user to be able to TAB or ARROW from one box to the next without traveling through each adjacent cell to get to it. Is this at all possible? (Please don't say VBA I'm not that advanced yet).
If you use the <End> key then press a cursor key the active cell will move to the first non-blank cell in the direction of the arrow, And if you have a block of filled cells this will move you to the ends of the block
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel Navigation
Thanks Much,
Kerry.shannon@galaxyhotelsystems.com