I have an excel sheet for recording test scores and grades where I’ve filled every other row with light gray for ease of reading. (One row per student, easy to follow a long row and not lose my place.)
When I’m filling in scores excel sometimes takes it upon itself to change the cell in question from unfilled to filled. Deleting and retyping in the same cell gives the same result, but copying a cell from elsewhere works to get the right result and the right background.
Anyone experience something similar and have any idea what excel is up to?
Sometimes Excel decides to guess what you want and just do it. It’s nice when it’s right, but it usually isn’t. In your situation, I would probably just go through and type in what I need to and then use the format painter to fix the background problem.
Select rows that you have colored corrected with your mouse or shift-arrow keys, and then click on the format painter button in the top left and then click on the offending rows to get them formatted the way you want.
You may find this page’s solution to shading every other row more to your liking than doing it manually:
Select the range of cells.
On the Format menu, click Conditional Formatting.
Under Condition 1, select Formula Is.
In the data entry box, type =MOD(ROW(),2)=1.
Click the Format button. In the Format Cells dialog box, click the Patterns tab.
Select a light-blue color, and then click OK.
In the Conditional Formatting dialog box, click OK.
If the background is merely cosmetic, I’d probably use the built in templates. If that’s already what you are doing, then, yeah, try Munch’s method. But, in my experience, Excel does not change anything if you use preformatted styles, rather than shading each cell individually (even if by formula).
The other thing I would do is use Freeze Panes so I could always see column A, which presumably is the student name. Helps with the problem of scrolling across long worksheets and losing track of which row you’re supposed to be working on.
I’ve had Excel go off on a tangent before and do weird formatting stuff that I finally determined was a corrupted spreadsheet. Try copying the data, formulas, and formatting to another sheet and see if it persists (using paste special).