Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to show hided lines in excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to show hided lines in excel
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. cradino wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show Grid Lines on Worksheet in Excel 2007 | Excel Discussion (Misc queries) | |||
How Can I show 3 different lines in one chart? | Charts and Charting in Excel | |||
How can I get excel to show ALL lines of wrapped text? | Excel Worksheet Functions | |||
Hided values appears when I'm copying/pasting it to other worksheet | Excel Discussion (Misc queries) | |||
charts hided with black cover | Charts and Charting in Excel |