Strange grey bar and numbers on left of screen

[Blind_Man_Dan]

Hi folks

Sorry the title isn't better, but I just have no other way to explain it!

I've spoken to Microsoft on Live Chat and they've seen a screenshot and they didn't know what was going on so I'm really hopeful someone here will know.

Just so it's described in text (not that it'll make it much easier) on the left of the row numbers, there's a grey area, with numbers (1 to 6 at the moment) at the top, and on some rows a minus or plus sign. Nothing much seems to come of clicking the top numbers, except one hides row 3, as does the - sign by it. I've another sheet where this happens, but not so many numbers across the top, but loads of rows with the minus sign by them.

screenshot on imgur.com

Many thanks in advance for any help!

Dan

 

[Eric W]

Welcome to MrExcel!

Sounds like you have Grouping turned on. Go to the Data tab and click Ungroup and see if that clears it up.

 

[Blind_Man_Dan]

Thanks for the suggestion Eric, however this hasn't resolved it at all.

Anyone have further suggestions that would be appreciated.

Thanks

Dan

 

[Logit]

Dan:

I agree that it is GROUPING. Select all the cells on the sheet then click on UNGROUP.

Without first selecting the affected range of cells, the UNGROUP will not perform it's task.

 

[MARK858]

Did you select the rows before clicking ungroup? asking because your image definitely looks like Grouping.
Try again (you will have to do it for each group) or try running the macro below.

Sub ShtUngroup()
    Cells("1,20000") = "x"
    With ActiveSheet.UsedRange
        '        .Rows.EntireRow.Hidden = False
        .Rows.Ungroup
        .ClearOutline
    End With
    Cells("1,20000") = ""
End Sub

Edit: Please note that the code above assumes that cell A20000 is blank, below all the grouping and below your last row of data. If any part is not true then amend the code to a cell that matches all the criteria.

 

[Blind_Man_Dan]

Thanks both so much, my mistake, I didn't select all, and then didn't think it was working as I had to repeatedly click ungroup.

Do you have any idea why it's grouping rows when I've not asked it to specifically?

Thanks again.

Dan

 

[MARK858]

Do you have any idea why it's grouping rows when I've not asked it to specifically?

Happy that you sorted it out, but I'm afraid that I have no idea why it was grouped in the first place, as it isn't something easy to do accidently.

...and welcome to the forum

 

[Logit]

You are welcome.