Solved

Office 2007 Textbox and Enter Keys

Posted on 2008-06-19
3
353 Views
Last Modified: 2010-05-18
This "feature" is new to Excel 2007.  If I create a new document and insert a text box.  The enter key on the main keypad (i.e. above the shift key) will due a true CRLF.  The enter key on the number pad (some keyboard) will not go down to the next line.  Why would these keys act differently in Excel 2007.  In Excel 2003 both enter keys give a CRLF.
My users really llike to use the number pad and think this is a pain.  Any ideas?
0
Comment
Question by:j_donald_c
  • 2
3 Comments
 
LVL 23

Expert Comment

by:redrumkev
ID: 21824374
J Donald C,

I never knew this issues existed (I don't use text boxes often) and I just tired it out, and yes, that is strange, how it works on my 2003, but not my 2007 version of Excel!

My suggestion would be to remap the keys on your keyboard so that the "number pad enter key" used the same code as the "return, enter" key located next to the alphabet keys. However, this would cause you to in effect only have 1 one enter key, thus other programs that may require 2, would not function correctly. But then again, your users might not use such programs and this would not be an issue.

http://www.download.com/3120-20_4.html?tg=dl-20&qt=keyboard%20mapper&tag=srch

Hope this helps,
Kevin
0
 

Author Comment

by:j_donald_c
ID: 21829833
Thanks for the confirmation Kevin.  Does Excel have a place to report/list "known bugs"?  I had already thought about re-maping the keys but for some reason I feel like that will come back to get me later with some other program.  Unless someone else has a magic wand, I'll just tell my users it's a "feature" of Excel 2007.
0
 
LVL 23

Accepted Solution

by:
redrumkev earned 500 total points
ID: 21831820
J donald C,

I am sure MS does not have a place to report known or unknown bugs, because their products never have problems (just joking). I do not know where this would be located.

However, I did find something about your issue, (more of the same really):
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&tid=3aa6211f-e2a6-4262-bc42-1d21e7a047cf&cat=en-us-office&lang=en&cr=US&sloc=en-us&m=1&p=1

It is a keymapping approach and yes, you are correct in that it is a solution, but what will be the consequences down the road? The unknown consequences are very scary, at least to me, so I usually try to leave things alone, but if your users are going crazy with text boxes, using them 20-30 times a day, the benefit might be worth the potential risk, at least during a trial period?!?

Hope this helps!
Kevin
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now