Grouping Not Capabable, why?

  • Thread starter Thread starter liamplynch
  • Start date Start date
L

liamplynch

I have a very big excel workbook with mulitple tabs. For some reason
one of the tab will not group rows when I highlight them and go to
Data, Group and Outline, Group. I can do it on other tabs of the
workbook but not one specific tab. Any ideas why? Thanks
 
I would check to see of you have any merged cells. click on the whole sheet,
then format cells / alignment and make sure the Merge Cells is not checked or
a grey check. then try again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting Rows with tabs grouped 2
Security 5
Recover lost excel tabs/spreadsheets from workbook 2
xls 2007 ribbon 2
Insert row in Master worksheet that auto inserts in other workshee 2
grouping multiple tables Excel 2007 3
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
Group page selection and deselection 2

Back
Top