Ask Your Question

Protecting a Cell Disables Users to Adjust the Width/Height?

asked 2017-12-20 01:19:16 +0100

Jerrymc777 gravatar image

I've created a financial spreadsheet for a colleague and try to Protect only the formula cells. It works, but if the user enters a larger dollar amount the cells show ### and the user CANNOT adjust the width or height of the columns or rows. I've tried everything I can think of to fix this... Any suggestions? Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-12-20 03:43:26 +0100

You cannot resize a protected cell; which implies that you cannot resize a column having at least a single protected cell. If your column consists of only unprotected cells, it may be resized (just tested with Which allows you to (re)structure your spreadsheet to have whole unprotected column to get it resizable. Other than that, protecting is protecting, so you have to provide enough space in advance for possible amounts of data at the spreadsheet construction phase. You are the creator of some king of application, and ignoring possible input is bug of yours.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-20 01:19:16 +0100

Seen: 580 times

Last updated: Dec 20 '17