ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I group columns? (https://www.excelbanter.com/excel-discussion-misc-queries/86680-how-do-i-group-columns.html)

Fuller

How do I group columns?
 
Whenever I try to group columns of a large spreadsheet, it shows "cannot
shift objecs off sheet." I have not reached the maximum columns, but the
Excel program clearly thinks I have. Why is this?

David McRitchie

How do I group columns?
 
Check your last cell Ctrl+End
use of merged cells might also be involved.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fuller" wrote in message ...
Whenever I try to group columns of a large spreadsheet, it shows "cannot
shift objecs off sheet." I have not reached the maximum columns, but the
Excel program clearly thinks I have. Why is this?





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com