+ Reply to Thread
Results 1 to 6 of 6

Questions on keeping my eyes from crossing | horizontal and vertical ?

  1. #1
    Registered User
    Join Date
    04-15-2024
    Location
    usa
    MS-Off Ver
    10.0.19044
    Posts
    3

    Questions on keeping my eyes from crossing | horizontal and vertical ?

    Hello!

    Just trying to learn the ways of the force which is excel tooling. These are basic situations that I am not sure if Excel has the tooling to help me with my challenges.
    I sometimes get lost in large data sets of what row I am in as I scroll from left to right and what column I am in as well (yes I can manually highlight the row or column completely but that is time intensive and not my overall goal to improve efficiency).
    My question: Is there a way for excel to follow me around from cell to cell kinda like a bullseye to differentiate the row and column temporarily(almost like highlighting)? For example if I am in column N, Row 995; I would like the entire Row 995 and Column N to be noticeably different visually while I am clicked into the cell, so I can keep track of the vertical and horizontal locations easier. Then when I click into column K row 995 the same thing happens with no manual inputs other than clicking into the cell. This would also leave N995 with no alterations in color or look as I am no longer in that cell.

    I am also clicking out of excel and back in quite allot and when I look back at the excel screen nothing is highlighted or different once I click out of the program so I lose track of the cell I was just in. That one is tough as well.

    Can anyone provide more guidance on my challenges??
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,294

    Re: Questions on keeping my eyes from crossing | horizontal and vertical ?

    Something like this with conditional format?
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    04-15-2024
    Location
    usa
    MS-Off Ver
    10.0.19044
    Posts
    3

    Re: Questions on keeping my eyes from crossing | horizontal and vertical ?

    popipipo this would more likely be a setting rather than a function. The end goal is ONLY to passively highlight temporarily while in a particular cell the vertical and horizontal lines that intersect with the cell I am clicked in(row and column). As I move through the doc into different cells the same process continues. At least that would be my hope.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,215

    Re: Questions on keeping my eyes from crossing | horizontal and vertical ?

    Please Login or Register  to view this content.
    Click on sheet tab, "View Code", copy/paste above code

    Click on any cell
    Attached Files Attached Files
    Last edited by JohnTopley; 04-15-2024 at 02:04 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  5. #5
    Registered User
    Join Date
    04-15-2024
    Location
    usa
    MS-Off Ver
    10.0.19044
    Posts
    3

    Re: Questions on keeping my eyes from crossing | horizontal and vertical ?

    John that is exactly what I was looking for! Thank you!

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,294

    Re: Questions on keeping my eyes from crossing | horizontal and vertical ?

    That is what my file also does (Row and column tab)
    The color in my file does not change after leaving the cel

+ 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. [SOLVED] All crossing should be filtered in different sheet crossing type
    By rajatds31 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2020, 08:37 AM
  2. Replies: 16
    Last Post: 06-01-2017, 06:01 PM
  3. Excel 2007 : Horizontal to vertical
    By godfredafrifa in forum Excel General
    Replies: 1
    Last Post: 11-06-2011, 11:54 AM
  4. Horizontal to Vertical
    By Jett in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-04-2007, 03:37 PM
  5. horizontal to vertical
    By mlecho in forum Excel General
    Replies: 1
    Last Post: 08-29-2007, 04:12 AM
  6. Keeping status on posed questions in Excel
    By Jaydubs in forum Excel General
    Replies: 5
    Last Post: 06-08-2006, 12:10 AM
  7. [SOLVED] Keeping Prying eyes out
    By Keith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2005, 09:05 AM

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