Is Keir Starmer Really Going To Arrest...
News2 mins ago
Excel - text cells and protecting sheets
0 Answers
I have a spreadsheet and I protect elements of it. When I do this though, the cells which are 'allowed for editing' and formatted as 'text' cells will allow users to input text BUT the problem is if they want to go back to the cell to amend the text, it wipes it all!
It does not happen when the document is not protected, but I need the document protecting (as other cells have formula in and they need to be kept safe and un-edited).
It does not happen when the document is not protected, but I need the document protecting (as other cells have formula in and they need to be kept safe and un-edited).
Answers
Best Answer
Nobody has yet answered this question. Once some answers have been given, funkylad20 will be able to select one answer as the best. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.There are no answers available for this question.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.