Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Go to Excel Help menu, type in limits
"Worksheet size 65,536 rows by 256 columns" Asking for more columns or rows is like standing on the Superdome and asking Katrina to stop and go back where it came. "Petronella Halldin" wrote: Hi, I have a basic queastion, but I can't find any given limitations written anywhere. I have managed to group, in two levels, columns from "H" to column "DA". I have more material that I want to group, but the work sheet wont accept my request. What happens: I CAN make the group, but when i press the "+"-sign to group them, I can't. I get a pop-up saying something like: "objects cannot be moved outside work sheet". If a open other groups, I can close later groups, but as I write, not all groups. Who has the answer to this one? Thank you all for you time! --- Petronella |
#2
![]() |
|||
|
|||
![]()
Maybe you have some objects that get rearranged when you hide the columns using
your grouping symbols. This may have some suggestions that work for you. It's kind of a similar problem. 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. Petronella Halldin wrote: Hi, I have a basic queastion, but I can't find any given limitations written anywhere. I have managed to group, in two levels, columns from "H" to column "DA". I have more material that I want to group, but the work sheet wont accept my request. What happens: I CAN make the group, but when i press the "+"-sign to group them, I can't. I get a pop-up saying something like: "objects cannot be moved outside work sheet". If a open other groups, I can close later groups, but as I write, not all groups. Who has the answer to this one? Thank you all for you time! --- Petronella -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
how can I extend number of columns in excel | Excel Discussion (Misc queries) | |||
Is there a maximum number of non-contiguous columns that can be h. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Change number of columns mid page? | Excel Worksheet Functions |