Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Small 1-2 on worksheet's left in Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paddy - 27 Oct 2006 17:11 GMT
I have a spreadsheet with several simple worksheets.

In one of the worksheets, at the very left, there has appeared a small "1
2".  Under that is a vertical line and a series of dots, one dot per row. At
the end is a minus sign.

If I click the "1", most of the spreadsheet disappears, showing only the
final total column with a plus sign on the left. If I click "2", the full
spreadsheet reappears.

I've tried searching Help to find out what this is and how to get rid of it,
but as I don't know it's name, function, purpose or how it got there, I'm
totally lost!

Please tell me what this is and how I can remove it.

(Microsoft Excel 2003)

Thank you
Ron Coderre - 27 Oct 2006 17:19 GMT
You've discovered "Outlining" in Excel!

Search Excel Help for: outline
Read the "About outlining a worksheet" topic

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> I have a spreadsheet with several simple worksheets.
>
[quoted text clipped - 15 lines]
>
> Thank you
Paddy - 27 Oct 2006 17:56 GMT
> You've discovered "Outlining" in Excel!
>
> Search Excel Help for: outline
> Read the "About outlining a worksheet" topic

Cool!

It's all fixed now.

Thanks, Ron, I'd never have found it by myself.

Paddy
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.