Gap between ruler and left frame Excel 2010

wilcowoods

Active Member
Joined
May 29, 2008
Messages
275
I should probably know this but it just hasn't come up!

I've just received a spreadsheet and on one sheet the ruler to the far left down the page is inset and there is a gap between the ruler and frame. At the top (just below the Name Box where you name ranges or set co-ordinates) and in the gap are two small squares with numbers inside. If you click on them they depress like buttons but don't appear to do anything.

Can anyone tell me what this is all about? I've also seen this gap between the ruler and the lettered rule across the top...

Thanks for any help!
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

repairman615

Well-known Member
Joined
Dec 21, 2009
Messages
1,885
Hello,
Sounds like "group". Try to zoom out and see if you can see any other abnormalities in that space. Or scroll as far as the used range.

Grouping is like hiding.

Could that be it?
Also what version?
 

wilcowoods

Active Member
Joined
May 29, 2008
Messages
275
Excel 2010 - and you're right there is a little square with + or - open and close between the two groups. I haven't used this before so I'll have to investigate what's going on. Now I know it's called "Group" I can investigate...
 

repairman615

Well-known Member
Joined
Dec 21, 2009
Messages
1,885
Yes, that should expand and contract columns in this case. This is also available for rows on the vertical.

Using 2007 here it is on the data tab...If that helps any as I have not used 2010.
 

wilcowoods

Active Member
Joined
May 29, 2008
Messages
275

ADVERTISEMENT

Thanks for your help. It's funny how many years I've been using Excel / VBA and I haven't used this!
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
G'day Will, hope things are well with you!

Those buttons and + - boxes can certainly appear when rows (or columns) are grouped manually using the 'Group' feature on the Data tab, but they also appear for rows if Excel's 'Subtotal' feature (also on the Data tab) has been used.
 

wilcowoods

Active Member
Joined
May 29, 2008
Messages
275
Hey Peter - good to hear you're still around on Mr Excel! Hope things are going well.

I'm investigating that bit of the ribbon as we speak - can't believe I've not played around with it before this - quite useful..

Thanks again!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,631
Members
414,082
Latest member
sasmita

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