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