Excel - Rows.PNG
Please see pic. I sometimes like to press F2 on a formula to see which rows its referencing. The problem is even though I can see which cells its using, I cant figure out which row on the left hand side it pertains to. For example in the picture when I press F2 on DW138, I can see its looking at the cell above that has a blue box around it, but I cant tell if that blue box is EGM or CGM. I have to keep looking carefully and drawing a mental line across to figure it out.
Is there a way around this?
When one clicks on a cell Excel (for example in DW138 here) Excel highlights the row number at least. In this case Row 138 has a highlight in the far left side. Is there some way to enable that so that when I press F2 on a cell all the resulting rows have some kind of highlight?
Bookmarks