Format

Question 1

Case control of text

Answer 1

formula: upper(), lower(), proper(), trim(), or

entire a few cell with correct format then select the entire field flash fill : Ctrl + E

Question 2

Protect cells in excel

Answer 2

select the cells that you do not want to protect, right click, format cells, Protect, de-select locked, click ok, review, protect sheet.