Are there buttons in the gray area that contain a plus sign or a minus sign?
When you click on the plus sign, hidden rows unhide.
Clicking on the minus sign hides grouped rows.
It that is your situation, see "outlining" in Excel Help.
If you want to remove all of the outlining...
From the Excel main menu:
<data><grouping and outlining><clear outline>
They could be caused by
Data|Group and Outline|Group
or by
Data|Subtotals.
You can remove those symbols by:
tools|Options|View tab|uncheck Outline symbols
Or you may want to remove the grouping/subtotals via the data menu.
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.