How to Fix Alt+Enter Not Working in Excel on Azure Virtual Desktop
Question details
The user is unable to insert a new line within an Excel cell because the Alt+Enter keyboard shortcut is being intercepted by the remote desktop environment.
- Product
- Microsoft Excel
- Device & OS
- Windows, Azure Virtual Desktop
- Scenario
- Editing a spreadsheet remotely via Azure Virtual Desktop or a Remote Desktop Protocol (RDP) client.
- Observed behavior
- Pressing Alt+Enter fails to create a line break inside the cell, as the remote client intercepts the keystroke instead of passing it to Excel.
Ensure that you are actively in cell edit mode by double-clicking the cell or pressing F2 before attempting to insert a line break.
Use Alternative Input Methods for Line Breaks
Bypass the RDP shortcut interception entirely by utilizing the Windows On-Screen Keyboard or the copy-paste function.
When your virtual desktop client captures physical keyboard shortcuts, you can use built-in Windows accessibility tools or text from another application to insert the required line break.
Place your cursor exactly where you want the line break to appear in the text.
Open the Windows Start menu, search for 'On-Screen Keyboard', open the app, and click the 'Alt' and 'Enter' keys on the virtual keyboard to insert the break.
Open a text editor like Notepad, press Enter to create an empty line break, copy it (Ctrl+C), return to Excel, and paste it (Ctrl+V) inside your cell.
Insert a Line Break Using a Formula
Use the CHAR(10) function to programmatically force a line break between text strings when keyboard shortcuts are unavailable.
Adjust Your Remote Desktop Client Settings
Configure your RDP client to pass all Windows key combinations directly to the remote computer, or switch to a different client.
Edit Spreadsheets Locally with WPS Office
Avoid remote desktop shortcut conflicts and latency entirely by editing your spreadsheets locally. WPS Office is a highly compatible, free alternative to Microsoft Office that handles Excel files seamlessly.
- 1. Download the software: Visit the official WPS Office website and download the free desktop application.
- 2. Install locally: Follow the on-screen instructions to install WPS Office directly on your computer.
- 3. Open your spreadsheet: Launch WPS Spreadsheet and easily edit your Excel files with full shortcut support, avoiding RDP limitations.
Frequently Asked Questions
Why is Alt+Enter intercepted by my Remote Desktop?
Remote Desktop Protocol (RDP) clients capture specific keyboard shortcuts to manage the remote session itself (such as switching windows or minimizing the client). Depending on your settings, commands like Alt+Enter may be processed by the client app instead of reaching Excel.
How do I make the line break visible after using the CHAR(10) formula?
For any manual or formula-based line break to display properly in Excel, you must select the cell, go to the Home tab on the ribbon, and click the 'Wrap Text' button.
Are there other shortcuts for inserting a new line in a spreadsheet?
On Windows, Alt+Enter is the universal shortcut for inserting an in-cell line break in Excel and WPS Spreadsheet. If you are using a Mac, the equivalent shortcut is Control+Option+Return or Alt+Command+Return.
