 | Junior Member with 9 posts. | | | | Solved: Excel Backspace Improper Functioning I'm using Excel 2007, Windows XP.
I have text in a cell.
I'm editing the ext in the window above the spreadsheet, where you can view cell contents.
When I press the backspace button, the character to the left of the curser is deleted, but the curser doesn't move.
Example: 1234 > put the curser between 2 and 3 > backspace > 134 but the curser is now between 3 and 4, instead of between 1 and 3.
Any help would be greatly appreciated | | Senior Member with 1,608 posts. | | Join Date: Feb 2006 Location: Market Rasen, Lincolnshire UK Experience: Advanced at times | | It works alright for me.
Could it be something to do with your keyboard/mouse cursor.
How old are you keyboard and mouse?
Are you using wireless keyboard/mouse? | | Junior Member with 9 posts. | | | | I don't know how old the keyboard and mouse are, but they have been working fine since 2005. This problem only started two days ago. | | Junior Member with 9 posts. | | | | this is not a wireless keyboard, or mouse.
Backspace is on the keyboard. Mouse seems to be functioning normally.
I think it's a configuration setting of some kind.
Just a guess. | | Senior Member with 1,608 posts. | | Join Date: Feb 2006 Location: Market Rasen, Lincolnshire UK Experience: Advanced at times | | Either that or your backspace key is getting knackered. Have you tried a new keyboard?
How old is your machine out of interest? | | Junior Member with 9 posts. | | | | I can try a different keyboard, but that would be wierd.
I have a Dell Latitude D630.
I have a workstation that I plug my laptop on.
I use a seperate keyboard in this configuration.
I just tried the backspace on the laptop keyboard, and it functions properly. Wierd.
I'll try a seperate keyboard, and see what happens.
thanks | | Senior Member with 1,608 posts. | | Join Date: Feb 2006 Location: Market Rasen, Lincolnshire UK Experience: Advanced at times | | Has this only happened today?
Have you tried closing down your computer and coming back in, to see if that makes any difference. | | Senior Member with 1,608 posts. | | Join Date: Feb 2006 Location: Market Rasen, Lincolnshire UK Experience: Advanced at times | | Well at least your keyboard on your laptop is OK.
Definately try another external keyboard and see how that behaves.
4 years is not bad for a keyboard!
I always use an external keyboard with my laptop when at home. | | Junior Member with 9 posts. | | | | this started two days ago.
I have restarted my laptop atleast twice since this started.
I was thinking about your comment about the backspace key getting "knackered", so a gave it a bit of a smack (the American solution to everything  ) and all seems to be forgiven.
It's working. wierder still. | | Junior Member with 9 posts. | | |
09-Oct-2009, 11:28 AM
#10 | It appears that I spoke to soon.
I tested this out on an unused cell, and all was fine.
Then I went back to the cell I was working in, and it's still not working.
so I'm thinking it's something about the formatting in this cell.
I'll investigate.
Any suggestions? | | Senior Member with 1,608 posts. | | Join Date: Feb 2006 Location: Market Rasen, Lincolnshire UK Experience: Advanced at times |
09-Oct-2009, 11:31 AM
#11 | That doesn't surprise me. Sounds like you need a new keyboard. They are relatively cheap these days.
Mind you, you probably had a bit of food or something like that in the keyboard :-)
Can you scroll to the top of the thread and click on Solved please | | Junior Member with 9 posts. | | |
09-Oct-2009, 11:34 AM
#12 | I don't think it's the keyboard.
The problem is only in selected cells.
I can't figurout what settings would create this behavior | | Senior Member with 1,608 posts. | | Join Date: Feb 2006 Location: Market Rasen, Lincolnshire UK Experience: Advanced at times |
09-Oct-2009, 11:35 AM
#13 | Well I think the first thing to do is
click on the offending cell and click on the Home tab on the ribbon.
Click on Delete in the cells section
Type some new data into the cell and press enter.
Then try editing the cell and see what happens | | Junior Member with 9 posts. | | |
09-Oct-2009, 11:39 AM
#14 | problem solved.
Thanks.
I'll mark this as solved.
I wonder if this can be caused by putting too much text in one cell? | | Senior Member with 1,608 posts. | | Join Date: Feb 2006 Location: Market Rasen, Lincolnshire UK Experience: Advanced at times |
09-Oct-2009, 12:09 PM
#15 | I don't think so
If you get any further problems post back on this thread. | |
Smart Search
| Find your solution! | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | |  WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
| You Are Using: |
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 05:41 AM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd. | |
|