SOLVED

Gray area on top and left side of worksheet??

%3CLINGO-SUB%20id%3D%22lingo-sub-2501540%22%20slang%3D%22en-US%22%3EGray%20area%20on%20top%20and%20left%20side%20of%20worksheet%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501540%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20Attached%20screen%20shot.%26nbsp%3B%20%26nbsp%3BI%20have%20clicked%20on%20something%20to%20display%20a%20gray%20top%20bar%20and%20left%20side%20on%20my%20worksheet.%26nbsp%3B%20%26nbsp%3BDoes%20anyone%20know%20what%20this%20is%20and%20how%20to%20turn%20off%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2501540%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2501586%22%20slang%3D%22en-US%22%3ERe%3A%20Gray%20area%20on%20top%20and%20left%20side%20of%20worksheet%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501586%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1091589%22%20target%3D%22_blank%22%3E%40RickA100%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20is%20an%20outline.%3C%2FP%3E%0A%3CP%3EActivate%20the%20Data%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EIn%20the%20Outline%20group%2C%20select%20Ungroup%20%26gt%3B%20Clear%20Outline.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2501614%22%20slang%3D%22de-DE%22%3ESubject%3A%20Gray%20area%20on%20top%20and%20left%20side%20of%20worksheet%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501614%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1091589%22%20target%3D%22_blank%22%3E%40RickA100%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Foutline-group-data-in-a-worksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EOutline%20(group)%20data%20in%20a%20worksheet%3C%2FA%3E%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3ETo%20display%20rows%20for%20a%20level%2C%20click%20the%20appropriate%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eoutline%20symbols.%3C%2FP%3E%3CP%3E2.%20Level%201%20contains%20the%20total%20sales%20for%20all%20detail%20rows.%3C%2FP%3E%3CP%3E3.%20Level%202%20contains%20total%20sales%20for%20each%20month%20in%20each%20region.%3C%2FP%3E%3CP%3E4.%20Level%203%20contains%20detail%20rows%20%E2%80%94%20in%20this%20case%2C%20rows%2017%20through%2020.%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E5.%20To%20expand%20or%20collapse%20data%20in%20your%20outline%2C%20click%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20outline%20symbols%2C%20or%20press%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3EALT%2BSHIFT%2B%3D%3C%2FSTRONG%3E%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20to%20expand%20and%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3EALT%2BSHIFT%2B-%3C%2FSTRONG%3Eto%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20collapse.%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*For%20example%2C%20see%20your%20inserted%20file%20in%20this%20message.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

See Attached screen shot.   I have clicked on something to display a gray top bar and left side on my worksheet.   Does anyone know what this is and how to turn off??

3 Replies

@RickA100 

It is an outline.

Activate the Data tab of the ribbon.

In the Outline group, select Ungroup > Clear Outline.

best response confirmed by allyreckerman (Microsoft)
Solution

@RickA100 

 

Outline (group) data in a worksheet

 To display rows for a level, click the appropriate 

 

 

 outline symbols.

2.  Level 1 contains the total sales for all detail rows.

3.  Level 2 contains total sales for each month in each region.

4.  Level 3 contains detail rows — in this case, rows 17 through 20.

5.  To expand or collapse data in your outline, click the 

 and  outline symbols, or press ALT+SHIFT+= to expand and ALT+SHIFT+- to collapse.

 

Hope I was able to help you with this info.

 

*For example, see your inserted file in this message.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

Thanks..... that worked