Solved

Office 2007 Textbox and Enter Keys

Posted on 2008-06-19
3
422 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

622 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