Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mike
 
Posts: n/a
Default Is there a limit in the number of columns that can be grouped?

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
concatenating and formatting area code and phone number columns sherri Excel Worksheet Functions 4 September 1st 05 09:59 PM
how can I extend number of columns in excel Anupam Excel Discussion (Misc queries) 2 August 9th 05 02:28 AM
Is there a maximum number of non-contiguous columns that can be h. Harold Excel Discussion (Misc queries) 6 March 1st 05 09:10 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Change number of columns mid page? Bluemax Excel Worksheet Functions 4 November 24th 04 02:11 AM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"