This is something I have been dealing with since we first got Excel 2000 (which we still have).
I use a lot of spreadsheets for keeping track of receiving tickets for our company. When several customers come on one ticket, I color code the rows so that it will stand out. Sometimes (not every time) when I type in a row below this color code, the cell will automatically fill in. What is making it do this?
Bookmarks