View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kassie kassie is offline
external usenet poster
 
Posts: 515
Default Viewing of protected locked or unlocked cells

One way is to protect the sheet, and untick Select locked cells. Repeatedly
pressing <Tab will then take you to the unlocked cells only.

--
HTH

Kassie

Replace xxx with hotmail


"jmisenar" wrote:

Is there a way to view an entire workshees to see which cells are locked and
unlocked?
--
Jan