Allow expand/collapse of Excel outlines on protected sheets


The Blue Max

Our enhancement request is to allow the user to expand or collapse Excel
outlines (grouped rows or columns controlled by the +\- icons in the
worksheet headings) when the worksheet is protected. This could be easily
provided as one of the many other options for 'editing exceptions' displayed
when protecting a worksheet.

This would be a huge visual usability asset to the end user. While the user
or designer often wants to lock the data or formatting, they do not
necessarily want to restrict the ability of the end user to show or hide the
same information. We have many templates that would benefit from the
flexibility of being able to quickly show or hide columns on a protected

One simple example is when the user is using a template in Excel as a tool
to enter information into another program, such as an accounting program. In
this case, Excel may be docked in a half-screen window for reference to an
application docked in another half-screen window. In such cases, the user
could hide columns in the worksheet so that pertinent information would be
quickly available in the resized Excel window. Zooming often makes the text
too small to be readable, but expanding/collapsng outlines preserves the
readability while displaying the desired information.

This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question