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??
Bookmarks