Strange grey bar and numbers on left of screen

Blind_Man_Dan

New Member
Joined
Sep 3, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,739
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

New Member
Joined
Sep 3, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Thanks for the suggestion Eric, however this hasn't resolved it at all.

Anyone have further suggestions that would be appreciated.

Thanks

Dan
 

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,948
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

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,952
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile

ADVERTISEMENT

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.

VBA Code:
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.
 
Last edited:

Blind_Man_Dan

New Member
Joined
Sep 3, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,952
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
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 (y)
 

Watch MrExcel Video

Forum statistics

Threads
1,126,896
Messages
5,621,495
Members
415,844
Latest member
Reda Fouad Ramzy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top