I'm having a problem with Excel 2013.
I have a spreadsheet filled with names and related information for applicants. When I contact the applicants, I highlight the cells (using the fill tool) so I know I've contacted them.
Here's the problem: if I have all my names highlighted, and I add more data, then after I tab or enter out of that new cell, Excel automatically applies highlighting. How can I get that to stop.
Summary of steps:
- Work in spreadsheet containing rows of data that has been highlighted using the fill tool. (Let's say that data is in rows 2-10 with a header row).
- Select cell A11.
- Type in new data.
- Hit "Tab" to move to the next cell.
- PROBLEM: Excel automatically applies the fill to A11 (and to A12, A13, etc. as I tab out of them).
Is there a setting to change that will prevent this behavior?