ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Worksheet ribbon (https://www.excelbanter.com/new-users-excel/218758-worksheet-ribbon.html)

Randy

Worksheet ribbon
 
I have a ribbon on a worksheet that only functions to hide and unhide hidden
columns. I do not know how this ribbon was inserted and I cannot find out
how to eliminate it. The other worksheets in the workbook do not have this
ribbon. Any help?

Khoshravan

Worksheet ribbon
 
You have used grouping.
Select the range which grouped by the ribbon
Go to Data| Group and Outline, select ungroup.
This should solve the problem.

"Randy" wrote:

I have a ribbon on a worksheet that only functions to hide and unhide hidden
columns. I do not know how this ribbon was inserted and I cannot find out
how to eliminate it. The other worksheets in the workbook do not have this
ribbon. Any help?



All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com