Go Back   PCMech Forums > Help & Discussion > Software Discussion & Support

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Old 04-08-2005, 05:58 AM   #1
Member (7 bit)
 
Join Date: Sep 2001
Location: Stamford England
Posts: 99
Excel reinstall - text replacement problem

After every install something new comes up!

I've just reinstalled XP SP2 and Office 2000.

I use Excel to keep my accounts, which include some textual description. To help enter this, I use a program called shortkeys to change: e.g. =pb to paperback.

This has worked fine in the past.

However after this install, instead of leaving the cursor within the Excel cell so I can add more text (or another abbreviation), the program defaults to focusing on the cell as awhole:
so if I type =pb
I get
paperback
But if I type anything else the whole cell is replaced by the next character.

I don't think this is an issue with shortkeys, which seems to work pretty simply, so I'm assuming that it is Excel.

I have only just started operating with XP SP2, so I suppose that could make a difference.

I can't see a suitable option to change to stop this so I can continue typing:
e.g.
Victor Gollancz 1973 First Edition hardback VG+

[I'm dealing with books here]

Grateful for any suggestions. It may be very obvious but it isn't to me.
__________________
jash
when the logos is common to all, the majority of men live as if they have a private understanding.
jash is offline   Reply With Quote
Old 04-08-2005, 11:36 PM   #2
Member (10 bit)
 
PMich's Avatar
 
Join Date: Jan 2001
Location: Greenville, MS
Posts: 625
So within a cell if you type:
=pb you get paperback
=pb a you get a
=pb asd you get a (or do you get asd)

The only thing I can think of is that perhaps excel is seeing a carriage return from shortkeys. Are you having trouble with all shortkey entries or just ones in particular. Is there an option in shortkeys that may be inserting a carriage return at the end of your abbreviation?

On another note, I know that this isn't a permanent fix but you can hit F2 to get a cursor within a selected cell.
PMich is offline   Reply With Quote
Old 04-09-2005, 01:13 AM   #3
Member (7 bit)
 
Join Date: Sep 2001
Location: Stamford England
Posts: 99
some changes

Hi
Thanks for your reply.
Things have changed slightly but I'm not sure why.
Now Excel is seeing a carriage return after each shortkey, so the focus moves to the next box (one down, or beginning of line depending).

Shortkeys does have extra symbols you can add to force e.g. , which works and moves you on to the next cell. But adding does not leave you with an insertion point after the shortkey - the carriage return still happens.

This does not happen when I insert text from the clipboard, but even setting shortkeys to work via the clipboard does not stop this extra behaviour.

I'll dig out my office Service packs, but I don't remember it ever doing this before.

I was hoping it was something obvious I wasn't seeing.

Every new install screws something up!!
J
jash is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 04:28 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2