Solved

Office 2007 Textbox and Enter Keys

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Office 2016 Install Options 11 70
excel VBA sending mail 9 54
how to compare 2 PST files? 3 117
Outlook 2016 - Change time of existing recurring appointment 2 19
Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
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…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

785 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