98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2007
Ashley has attended:
Excel Intermediate course
Excel Advanced course
Word Advanced course
Word Intermediate course
Excel
If an area within a sheet has been unprotected to allow changes but the rest of the sheet has been locked how can you show the unprotected area so this can then be protected? Say if you forget which area is unprotected.
RE: Excel
Hello Ashley
Thank you for your question and welcome to the forum.
It appears that there is no easy way of getting Excel to select unlocked cells for you (i.e. the cells that people can edit/change in a spreadsheet when protection is applied).
It may be useful to note that when protection is applied to the spreadsheet, if you press the Tab key, Excel will only select cells that are unlocked/can be changed.
So if you wanted to identify these cells, you could press the Tab key, then say colour each cell so you knew which ones are unprotected.
Apart from this it appears you would need to write some VBA code to get Excel to select all the unprotected cells at once!
See http://spreadsheetpage.com/index.php/site/tip/selecting_all_unlocked_cells/
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |