ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   data ribbon is greyed out (https://www.excelbanter.com/excel-discussion-misc-queries/212005-data-ribbon-greyed-out.html)

Northwoods

data ribbon is greyed out
 
I would like to use features of the data ribbon for my spreadsheet. However,
the entire ribbon is greyed out. I must have done something. I only have this
problem with this workbook.

Shane Devenshire[_2_]

data ribbon is greyed out
 
Hi,

check to make sure you are not in Group mode - look at the Excel title bar
and see if you see [Group]. If you do then you have more than one sheet
selected and virtually nothing on the Data ribbon can be used against
multiple sheets. Right click the sheet tab and choose Ungroup sheets.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Northwoods" wrote:

I would like to use features of the data ribbon for my spreadsheet. However,
the entire ribbon is greyed out. I must have done something. I only have this
problem with this workbook.



All times are GMT +1. The time now is 02:18 PM.

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