Cannot use keyboard shortcuts to select ranges in RefEdit control in Excel

Article ID: 291110 - View products that this article applies to.
This article was previously published under Q291110
Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986
(http://support.microsoft.com/kb/256986/ )
Description of the Microsoft Windows registry
Expand all | Collapse all

On This Page

Symptoms

When you use a RefEdit control in a user form, you cannot use keyboard shortcuts, such as CTRL+SHIFT+END, to enter a range in the RefEdit control.

Additionally, if you launch the Chart Wizard or the PivotTable Wizard from the popup menu, when you hold down CTRL+ARROW key to select a range in the PivotTable Wizard or in the Chart Wizard, the shortcut key does not work correctly.
Back to the top | Give Feedback

Workaround

To have us fix this problem for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.

Fix it for me



To fix this problem automatically, click the Fix it button or link. Click Run in the File Download dialog box, and follow the steps in the Fix it wizard.


Fix this problem
Microsoft Fix it 50346


Notes
  • You must have Microsoft Office 2000 Service Pack 3 or later versions installed to run the Fix it solution for Microsoft Office 2000.
  • You must have Microsoft Office 2002 Service Pack 2 or later versions installed to run the Fix it solution for Microsoft Office 2002.
  • This wizard may be in English only; however, the automatic fix also works for other language versions of Windows.
  • If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Let me fix it myself

To work around this issue, use one of the following methods:

Method 1: Add the registry key

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756
(http://support.microsoft.com/kb/322756/ )
How to back up and restore the registry in Windows

How to turn on the hotfix by using the QFE_Richmond registry key

To turn on the hotfix that is listed in this article, add the following registry key and value, according to the version of Excel that you are running.

Excel 2000

  1. Exit Excel if it is running.
  2. Click Start, click Run in the Open box, type regedit, and then click OK.
  3. Locate and then click the following registry key:
    HKEY_CURRENT_USER\software\microsoft\office\9.0\Excel\options
  4. On the Edit menu, click New, and then click DWORD value.
  5. Type QFE_Richmond for the new value, and then press ENTER.
  6. Right-click the QFE_Richmond registry key, and then click Modify.
  7. In the Value data box, type 1.
  8. Click OK, and then exit Registry Editor.

Excel 2002

  1. Exit Excel if it is running.
  2. Click Start, click Run in the Open box, type regedit, and then click OK.
  3. Locate and then select the following registry key:
    HKEY_CURRENT_USER\software\microsoft\office\10.0\Excel\options
  4. On the Edit menu, click New, and then click DWORD value.
  5. Type QFE_Richmond for the new value, and then press ENTER.
  6. Right-click the QFE_Richmond registry key, and then click Modify.
  7. In the Value data box, type 1.
  8. Click OK, and then exit Registry Editor.

Excel 2003

  1. Exit Excel if it is running.
  2. Click Start, click Run in the Open box, type regedit, and then click OK.
  3. Locate and then select the following registry key:
    HKEY_CURRENT_USER\software\microsoft\office\11.0\Excel\options
  4. On the Edit menu, click New, and then click DWORD value.
  5. Type QFE_Richmond for the new value, and then press ENTER.
  6. Right-click the QFE_Richmond registry key, and then click Modify.
  7. In the Value data box, type 1.
  8. Click OK, and then exit Registry Editor.

Excel 2007

  1. Exit Excel if it is running.
  2. Click Start, click Run in the Open box, type regedit, and then click OK.
  3. Locate and then select the following registry key:
    HKEY_CURRENT_USER\software\microsoft\office\12.0\Excel\options
  4. On the Edit menu, click New, and then click DWORD value.
  5. Type QFE_Richmond for the new value, and then press ENTER.
  6. Right-click the QFE_Richmond registry key, and then click Modify.
  7. In the Value data box, type 1.
  8. Click OK, and then exit Registry Editor.

Excel 2010

  1. Exit Excel if it is running.
  2. Click Start, click Run in the Open box, type regedit, and then click OK.
  3. Locate and then select the following registry key:
    HKEY_CURRENT_USER\software\microsoft\office\14.0\Excel\options
  4. On the Edit menu, click New, and then click DWORD value.
  5. Type QFE_Richmond for the new value, and then press ENTER.
  6. Right-click the QFE_Richmond registry key, and then click Modify.
  7. In the Value data box, type 1.
  8. Click OK, and then exit Registry Editor.

Excel 2013

  1. Exit Excel if it is running.
  2. Click Start, click Run in the Open box, type regedit, and then click OK.
  3. Locate and then select the following registry key:
    HKEY_CURRENT_USER\software\microsoft\office\15.0\Excel\options
  4. On the Edit menu, click New, and then click DWORD value.
  5. Type QFE_Richmond for the new value, and then press ENTER.
  6. Right-click the QFE_Richmond registry key, and then click Modify.
  7. In the Value data box, type 1.
  8. Click OK, and then exit Registry Editor.


Method 2: Use the mouse to select the range

When you are in the Wizard RefEdit Control, use the mouse to select the range instead of using the keyboard shortcut.

Method 3: Use the toolbar instead of right-clicking the menu

This issue does not occur if you use the menu instead of right-clicking to invoke the PivotTable Wizard. To do this, click PivotTable and PivotChart Report on the Data menu.
Back to the top | Give Feedback

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem was first corrected in Microsoft Office 2000 Service Pack 3 (SP-3).
Back to the top | Give Feedback

Properties

Article ID: 291110 - Last Review: November 1, 2012 - Revision: 14.0
Applies to
  • Microsoft Excel 2013
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbfixme kbmsifixme kbqfe kbhotfixserver kbOffice2000SP3Fix kbfix kbbug KB291110
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top