Excell Cells: Auto Formatting

  • Thread starter Thread starter Sophie
  • Start date Start date
S

Sophie

I have protected a workesheet and unfortunately when the people submit
information on the cells and it is too long than the actual height of the row
and it wont extend. What can I do?
 
When protecting the sheet allow users to format cells and rows.


Gord Dibben MS Excel MVP
 
How do I just have it automatically do that for me without granting them that
permission?
 
Before protecting the sheet set cells to wrap text and rows to autofit.

Then protect the sheet and only allow "select unlocked cells"

The wrapping and autofitting will happen.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected sheet accepting values from List 3
Auto fit text in cell of a protected worksheet 3
Excel 2007 - Rows - Height - AutoSize question 1
Auto Cell Height Adjustment for text entered 3
Cells ignore Wrap Text formatting! 2
Wrap Text doesn't work in Merged Cell 1
Protection and row height 3
How to control row height and text wrap in non-merged cell ??? 2

Back
Top