Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal error to expand Outline Levels
I am able to arrange my data with subtotals and they group effectively into
outline levels. I can also expand and collapse each grouping by clicking individual "+" and "-" signs. However, when I click "1", "2", or "3" to collapse the groupings of the outline levels, I get an error message. The error reads "cannot shift objects off sheet". My sheet is over 44000 rows. Why is this happening? Is the number of rows a factor? Please help. It takes quite a long time to expand each level manually with the plus and minus signs. Thanks, Michelle YVR Airport Authority |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal error to expand Outline Levels
Maybe...
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. Michelle wrote: I am able to arrange my data with subtotals and they group effectively into outline levels. I can also expand and collapse each grouping by clicking individual "+" and "-" signs. However, when I click "1", "2", or "3" to collapse the groupings of the outline levels, I get an error message. The error reads "cannot shift objects off sheet". My sheet is over 44000 rows. Why is this happening? Is the number of rows a factor? Please help. It takes quite a long time to expand each level manually with the plus and minus signs. Thanks, Michelle YVR Airport Authority -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal Levels not showing in Excel | Excel Worksheet Functions | |||
Group / Outline / subtotal | Excel Discussion (Misc queries) | |||
Multiple Subtotal levels in Excel 2003 | Excel Worksheet Functions | |||
No Buttons to Control Subtotal Levels!?!? | Excel Discussion (Misc queries) | |||
How do I get Multiple subtotal levels in EXCEL? | Excel Discussion (Misc queries) |