'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Worksheet Tab Names Cannot Include Spaces
Question details
The user is unable to type spaces when attempting to rename a worksheet tab in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Renaming an existing worksheet tab or creating a new tab in a workbook.
- Observed behavior
- Pressing the spacebar while typing a new worksheet tab name fails to insert a space, particularly in Excel for the web, even though spaces are officially supported.
Verify that your intended worksheet name does not exceed 31 characters and excludes unsupported symbols like slashes, asterisks, or brackets before applying any workarounds.
Use the Copy and Paste Workaround in Excel for the Web
Bypass the typing glitch in Excel for the web by copying text that already contains spaces and pasting it directly into the tab name.
While standard Excel rules allow spaces in worksheet names, certain versions of Excel for the web have an input bug that ignores the spacebar while renaming tabs. Pasting text circumvents this input restriction.
Type your desired worksheet name, including spaces, in a blank cell within your spreadsheet or in an external text editor like Notepad.
Highlight the typed text and press Ctrl+C (Windows) or Cmd+C (Mac) to copy it to your clipboard.
Double-click the worksheet tab you want to rename at the bottom of the Excel screen to highlight the current name.
Press Ctrl+V (Windows) or Cmd+V (Mac) to paste the copied name into the tab, then press Enter to save.
Edit the Workbook in the Excel Desktop Application
Switching to the desktop version of Excel avoids the web-based spacebar bug entirely.
Verify File Integrity and Rule Limitations
Ensure your desired name complies strictly with Excel's naming rules and test a fresh file to rule out document corruption.
Use WPS Spreadsheet to Seamlessly Rename Worksheets
WPS Spreadsheet provides a stable, glitch-free environment for organizing your data. You can easily rename worksheet tabs with spaces and other supported characters without dealing with frustrating web browser input bugs.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
- 2. Select the worksheet tab: Locate the worksheet tabs at the bottom of the workspace and double-click the specific tab you wish to rename.
- 3. Type the new name: Type your desired name with spaces directly using your keyboard.
- 4. Save the changes: Press the Enter key or click anywhere outside the tab to apply the new name.
Frequently Asked Questions
What characters are strictly forbidden in Excel worksheet names?
You cannot use the following characters when naming an Excel worksheet: forward slash (/), backslash (\), question mark (?), asterisk (*), colon (:), and square brackets ([]).
What is the maximum character limit for an Excel worksheet tab?
An Excel worksheet name can contain a maximum of 31 characters. If you attempt to type or paste a name longer than this, Excel will reject the input.
Can I use an apostrophe in an Excel sheet name?
You can use an apostrophe inside the worksheet name (e.g., "John's Data"), but the name cannot begin or end with an apostrophe.
Why does the spacebar stop working only in Excel for the web?
This is a known input glitch in certain versions of Excel for the web where browser key events for the spacebar are not properly registered in the tab renaming field. Using the desktop app or pasting text bypasses this issue.
