Solved

Office 2007 Textbox and Enter Keys

Posted on 2008-06-19
3
365 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

939 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

11 Experts available now in Live!

Get 1:1 Help Now