| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell Cells: Auto Formatting
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Cells: Auto Formatting
When protecting the sheet allow users to format cells and rows.
Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 13:14:01 -0800, Sophie wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Cells: Auto Formatting
How do I just have it automatically do that for me without granting them that
permission? "Gord Dibben" wrote: When protecting the sheet allow users to format cells and rows. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 13:14:01 -0800, Sophie wrote: 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? . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell Cells: Auto Formatting
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 On Thu, 11 Feb 2010 13:16:06 -0800, Sophie wrote: How do I just have it automatically do that for me without granting them that permission? "Gord Dibben" wrote: When protecting the sheet allow users to format cells and rows. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 13:14:01 -0800, Sophie wrote: 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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with cells auto formatting | Excel Discussion (Misc queries) | |||
| auto locking of excell workbook (excell 2003) | Excel Discussion (Misc queries) | |||
| Excell cells in worksheet will not accept new formatting. Help | Excel Discussion (Misc queries) | |||
| Stop cells auto-formatting | Excel Discussion (Misc queries) | |||
| Auto Formatting Cells and Dates | Excel Discussion (Misc queries) | |||
Linear Mode
