View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Protecting locked cells

If you select a few cells (say A:C), then do Data|Group and outline|group,
you'll see that you get outlining symbols across the top.

It can be useful if you want to hide/show columns (or rows) quickly.

Sheila D wrote:

Not quite sure what you mean by group and ungroup columns?

"Zakynthos" wrote:

I would like to protect locked cells in a worksheet but at the same time
allow the user to group and ungroup columns.

Can this be done?

Many thanks.


--

Dave Peterson