This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have an excel spreadsheet, which I lock for control reasons. There is a small section in which I have an unlocked merged cell in which others are allowed to type. Is there any way to format this merged cell so that when I lock the sheet, it will behave as "word"?
Many here at work are not familiar with working in excel, but are familiar with word. Mainly they want to "tab" and just have it tab over a bit within the cell, and press enter to have it move down, but within the cell. You the get "tab" to work if you have inserted a text box, but only if I leave the sheet unlocked - not gonna happen. If the sheet is locked, they can still type in the text box, but the tab moves to the next cell, not "tabbed over" within the cell. Is there some other way in which to insert a "mini word" sort of area within an excel spreadsheet?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
How about Insert>Object>Microsoft Word Document?
Size as you wish to start.
You can lock cells so's user cannot edit those but leave the "Edit Objects" checked.
Users can right-click on the Object and choose Document Object>Edit.
Gord