How to show hided lines in excel

C

cradino

I have using group command hided some lines. I have ungrouped al lines. How
can I show hided lines? This was made, in previeus versions, by right clic
under lines no show selected.
 
D

Dave Peterson

I'd try this first.

Use the outlining symbols to the left of the worksheet window. Click on the
highest number (should be the rightmost number) to see all the rows in all the
grouped rows.

If you can't see the outlining symbols, then use:
tools|options|view tab|check Outline Symbols

If you still have hidden rows, maybe they were just hidden manually.

Select the visible row on the top of that range through the visible cell on the
bottom of that range. Then Format|Row|Unhide.

If that still doesn't help, make sure you're not hiding rows via
Data|filter|autofilter. Try data|filter|show all.

And if that doesn't work and you're missing the rows at the top of your
worksheet, maybe you've frozen the panes so that those rows are just off the
window.

Window|Unfreeze Panes


All these menu items were in xl2003.
 

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

Top