Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to group a set of rows then hide them. Once hidden can you make it display some sort of text message.

Like right now it just hides the rows.

It is not very obvious that the rows are hidden. Can you give a message to be shown when hidden sort of like regions in C#

region hi
// some code

if you collapse(hide) the region you will see at least "hi" and no right off the bat that something is hidden.

share|improve this question
up vote 0 down vote accepted

I think the expectation if you're grouping rows in Excel 2007 (on the Data tab/toolbar for those unfamiliar) is that you're grouping the data used to generate totals that are shown on the row immediately following the group. It's basically just a friendlier way to do what you've always been able to do with hiding rows/columns, and the grouping indicators in the margins are there to show you that something's hidden.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .