![]() |
#1
|
|||
|
|||
![]()
I've stuggled with this for 3 days and have looked through all related posts I can bring up through search. I have found several replies that suggested fixes--it appears there are many recently who are dealing with this issue. I've worked through all of them but nothing has worked. I even copied the spreadsheet to a new blank workbook. I was trying to type in 8.25. It let me type in the 8 digit, but then wouldn't let me type anymore. Instead it jumps up to the next row--same thing it was doing in the original spreadsheet. Has anyone had experience working through this problem?
|
#2
|
||||
|
||||
![]()
Can you post the problem sheet here? It shouldn't need any data on it, just say which cells you're trying to use that don't work.
|
#3
|
|||
|
|||
![]()
I've attached the spreadsheet to this reply.
Update on problem: typing in numbers. When this happens I can't type numbers in any cell. I can type words. After saving the spreadsheet or when I shut down the computer and start back up it will sometimes let me type 1 digit or sometime several, but it always shuts me out. The wierd thing is that when I try to type in a number after it shuts me out it bounces to an adjoining cell--either up, down, or to the left. |
#4
|
||||
|
||||
![]()
I can type freely anywhere in that sheet. Do you only have the problem with this one worksheet?
|
#5
|
|||
|
|||
![]()
I have had problems with other worksheets but it turned out those problems were caused by reference back to another worksheet. When I solved the reference problem it went away. This worksheet doesn't refer to any other worksheet.
With this worksheet try deleting some numbers and retype numbers back into those cells. Save the file, open it back up and again try typing in numbers. See if you can get the problem to surface after typing in numerous cells. |
#6
|
|||
|
|||
![]()
I have been entering numbers from the number pad. I just double-clicked in a cell. It showed the cursor so I decided to type the number using the keys along the top of the keyboard. I checked the number pad and my NumLock wasn't on. Sheesh!!! so many ways to stub a toe. Probably operator error, but I will post once more to inform whether or not this completely solved the problem.
Thank you for looking at this. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
msnarayanan | Excel | 4 | 07-29-2015 06:16 AM |
![]() |
pejpr | Excel | 4 | 05-06-2015 10:14 AM |
Excel 2013 drops all numbers if I save to Dropbox | danbell | Excel | 0 | 09-01-2014 03:41 PM |
![]() |
HankBrandenburg | Word Tables | 1 | 02-17-2014 03:04 PM |
Filling cells with random numbers using loops? (VBA) | Sajj | Excel Programming | 4 | 04-10-2013 02:29 PM |