Solved

Office 2007 Textbox and Enter Keys

Posted on 2008-06-19
3
411 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 IT Pros

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

752 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