Forum Discussion
Malcolm McMaster
Aug 06, 2020Copper Contributor
Highlight active cell
Does anybody know how to highlight the active cell selection in Excel. I have a large table of data in which recurring values are often searched for and whilst the search is accurate enough, it's sti...
mtarler
Aug 06, 2020Silver Contributor
Malcolm McMaster I get what you are saying. Here are a few tips that might help you if you don't know them already:
1) to the left of the formula bar (where you type values in) is a box that shows the location of the current selection. That will help you know where to look
2) the row and column headers for the selected cell(s) are slightly darker so you can zoom in on the right location
3) you can always click the FILL button to make the cell(s) yellow (or whatever color you choose) and then click it again and select to remove that fill