+ Reply to Thread
Results 1 to 13 of 13

Navigate across sheet using arrow

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Navigate across sheet using arrow

    Hello everyone
    I have multiple headers .. so many and I need easy way to move across the sheet using arrow
    For example : I can see columns A:P
    I need when click the arrow to see R:AG and the arrow goes with me ..
    just this is just example ... I need to adjust it to fit the screen resolution as possible as I can
    Thanks advanced for any help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Navigate across sheet using arrow

    That functionality is built into the Excel Scroll Bars

    If to click into the space past the vertical or horizontal scroll bars then Excel will scroll to the next page.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Navigate across sheet using arrow

    You can press "scroll Lock" in keyboard then use arrows to move screen fast in all directions.

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Navigate across sheet using arrow

    Thanks a lot for replies
    In fact I don't need to use scroll bars for some reasons .. I need a macro to navigate easily using the arrow and the arrow would be moved across the sheet

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Navigate across sheet using arrow

    Any help in this topic please?

  6. #6
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Navigate across sheet using arrow

    I am working on this.

    I have a possible solution.

    BRB

  7. #7
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Navigate across sheet using arrow

    Please Login or Register  to view this content.

    This works too

    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Navigate across sheet using arrow

    Thanks a lot for reply
    As for the first only is working
    Please Login or Register  to view this content.
    But how can I move the arrow across the sheet ..

    And if possible to have another reversing arrow related to it to do the verse .. I mean to across back to the sheet
    Thanks a lot for help

  9. #9
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Navigate across sheet using arrow

    Please Login or Register  to view this content.

  10. #10
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Navigate across sheet using arrow

    Thanks for reply
    Scrolling to right is working well but to left not working ..that's point
    And another important point I need to move the arrow shape when running the code ... and the same for the other shape for left ..
    These shapes should be moved with me either scroll to the right or to the left

  11. #11
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Navigate across sheet using arrow

    You could add a left arrow and attache the arrows to these routines
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  12. #12
    Registered User
    Join Date
    04-25-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Navigate across sheet using arrow

    You could assign macros to various arrows that you place in the far left column, then freeze that column so it's always visible. The macros would jump the user to various parts of the page.

  13. #13
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Navigate across sheet using arrow

    Mr. Mikerickson
    That's exactly what I was searching for. That's wonderful and awesome
    Thanks a lot for great help and best regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Navigate to sheet via VBA
    By ola7mat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2012, 05:13 PM
  2. navigate through defined values in cell with arrow key
    By serge2487 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2011, 01:30 AM
  3. Replies: 2
    Last Post: 11-11-2009, 01:38 PM
  4. [SOLVED] I can't navigate my sheet with my arrow keys. suggestions?
    By Mark in forum Excel General
    Replies: 2
    Last Post: 10-14-2009, 06:41 AM
  5. Replies: 1
    Last Post: 06-15-2006, 02:45 PM
  6. navigate sheet onclick
    By nshanmugaraj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2006, 06:27 AM
  7. [SOLVED] Navigate in sheet with a button
    By Jonas G in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2005, 08:05 AM
  8. How so I navigate in Excel with arrow keys?
    By octobais9 in forum Excel General
    Replies: 1
    Last Post: 05-05-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1