| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Small 1-2 on worksheet's left in Excel
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Small 1-2 on worksheet's left in Excel
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 "Paddy" wrote: 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Small 1-2 on worksheet's left in Excel
"Ron Coderre" wrote:
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you protect hidden linked worksheets with in an Excel workb | Excel Discussion (Misc queries) | |||
| Excel User Conference - Few hours left - Early Bird pricing | Excel Discussion (Misc queries) | |||
| Comparing worksheets in Excel and highlighting changes | Excel Worksheet Functions | |||
| How do I sort worksheets in excel? i.e. Order them by date | Excel Worksheet Functions | |||
| In only Excel, my mouse behaves as if the left button is held dow. | Excel Discussion (Misc queries) | |||
Linear Mode
