my excel spreadsheet won't accept new data

10291 Excel 2010 home and student (full...
May 6, 2015 at 11:42:41
Specs: Windows 7, Intel i3 2120, 3.3Ghz, 6.0 GB
I'm trying to enter data in a spreadsheet I use weekly. It will not enter anything (no numbers/no letters) in the highlighted space. My keyboard is working fine with Word and also with a new Excel spreadsheet.

See More: my excel spreadsheet wont accept new data

Report •


#1
May 6, 2015 at 11:54:00
Does anyone else have access to the sheet?

Check your FONT colors to make sure they have not been changed to white.

MIKE

http://www.skeptic.com/


Report •

#2
May 6, 2015 at 12:09:27
No one else has access. I get fine entries on a new document, color is not the problem.

Report •

#3
May 6, 2015 at 12:48:17
Did you protect the sheet/workbook by any chance? Might you have a backup?

Report •

Related Solutions

#4
May 6, 2015 at 13:33:18
When you enter a character in a cell
and before you press enter,
can you see the characters you are entering?

MIKE

http://www.skeptic.com/


Report •

#5
May 7, 2015 at 13:15:18
Mike - No - nothing.

Report •

#6
May 7, 2015 at 13:17:53
I do not have a back-up. But, I can print everything entered so far.

Report •

#7
May 7, 2015 at 13:25:09
When you enter a character in a cell
and before you press enter
can you see the character in the Formula Bar?

But, I can print everything entered so far.

Even the stuff you can't see?

MIKE

http://www.skeptic.com/


Report •

#8
May 7, 2015 at 13:36:10
No, not the stuff I can't see. I notice now my curser arrow turns into a plus sign when I move over the document. I don't know if that was happening yesterday.

Report •

#9
May 7, 2015 at 13:48:31
When you enter a character in a cell
and before you press enter
can you see the character in the Formula Bar?

I still think it could be your Font Color.

Check to make sure there are no rogue Macros running
and also check for any Conditional Formatting.

Does it occur on all Sheets in the Workbook
or just one specific sheet?

What version of Excel are you using?
If your on 2007 or newer, try saving the workbook in a different format like .xls
and see if it continues to give the same problem.

MIKE

http://www.skeptic.com/


Report •

#10
May 7, 2015 at 14:16:27
Mike - Thanks for your help. I don't know what I did, but, it is now working properly (and I see the curser changing to plus is correct). FYI - It occured on all sheets in that workbook, but, not in other workbooks. I have Office 2010. I had changed the color to red, green, and black - nothing.

Report •

#11
May 7, 2015 at 14:27:10
Glad you got it sorted out.

MIKE

http://www.skeptic.com/


Report •

Ask Question