Mourning the loss of our friend, WhitPhil.
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
 
Business Applications
Tag Cloud
access audio black screen blue screen boot bsod connection crash dell desktop driver dvd email error excel firefox hard drive hardware hijackthis internet keyboard laptop malware monitor network networking outlook problem processor ram recovery registry cleaner router safe mode slow sound spyware tdlwsp.dll trojan upgrade vba video virus vista vundo windows windows 7 windows vista windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Excel Backspace Improper Functioning

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

 
Thread Tools
MikeGrumbach's Avatar
Junior Member with 9 posts.
 
Join Date: Oct 2009
09-Oct-2009, 10:26 AM #1
Exclamation 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
The Villan's Avatar
Senior Member with 1,608 posts.
 
Join Date: Feb 2006
Location: Market Rasen, Lincolnshire UK
Experience: Advanced at times
09-Oct-2009, 11:09 AM #2
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?
MikeGrumbach's Avatar
Junior Member with 9 posts.
 
Join Date: Oct 2009
09-Oct-2009, 11:13 AM #3
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.
MikeGrumbach's Avatar
Junior Member with 9 posts.
 
Join Date: Oct 2009
09-Oct-2009, 11:15 AM #4
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.
The Villan's Avatar
Senior Member with 1,608 posts.
 
Join Date: Feb 2006
Location: Market Rasen, Lincolnshire UK
Experience: Advanced at times
09-Oct-2009, 11:18 AM #5
Either that or your backspace key is getting knackered. Have you tried a new keyboard?

How old is your machine out of interest?
MikeGrumbach's Avatar
Junior Member with 9 posts.
 
Join Date: Oct 2009
09-Oct-2009, 11:23 AM #6
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
The Villan's Avatar
Senior Member with 1,608 posts.
 
Join Date: Feb 2006
Location: Market Rasen, Lincolnshire UK
Experience: Advanced at times
09-Oct-2009, 11:23 AM #7
Has this only happened today?

Have you tried closing down your computer and coming back in, to see if that makes any difference.
The Villan's Avatar
Senior Member with 1,608 posts.
 
Join Date: Feb 2006
Location: Market Rasen, Lincolnshire UK
Experience: Advanced at times
09-Oct-2009, 11:25 AM #8
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.
MikeGrumbach's Avatar
Junior Member with 9 posts.
 
Join Date: Oct 2009
09-Oct-2009, 11:26 AM #9
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.
MikeGrumbach's Avatar
Junior Member with 9 posts.
 
Join Date: Oct 2009
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?
The Villan's Avatar
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
MikeGrumbach's Avatar
Junior Member with 9 posts.
 
Join Date: Oct 2009
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
The Villan's Avatar
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
MikeGrumbach's Avatar
Junior Member with 9 posts.
 
Join Date: Oct 2009
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?
The Villan's Avatar
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.
Reply Bookmark and Share

Tags
backspace, excel, functioning, improper

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.

Thread Tools


You Are Using:
Server ID
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.
Powered by Cermak Technologies, Inc.