When working with slicers in Excel, it is common to filter, delete, add, or manipulate data to achieve the desired outcome. Let’s consider a scenario where we have a dataset and a pivot table at the bottom of the sheet, along with two slicers for the state and product. In this cas...
Here are the different ways to unlock the greyed-out menus in Microsoft Excel on Windows 11/10: Hit the Enter button to unlock the grayed-out menu. Unprotect Sheet/Workbook to unlock the grayed-out menu. Ungroup worksheets to unlock the grayed-out menu. Change Advanced Options to unlock the...
The track changes option becomes greyed due to various reasons. One of the reasons is that your workbook is protected with a password. Step 1: From the “Review” option select “UnprotectSheet”. Enter the password to unprotect the worksheet. PressOKto continue. The “TrackChanges” option w...
Some users report that they just can’t delete worksheets in a workbook. Either theDelete Sheetoption is greyed out or it won’t work correctly. They also reported being unable to delete the sheet from its right-click context menu. How do I enable a Delete Sheet in Excel? To be able t...
at Sy Table to Outlook by VBA doesn't have bottom border Textbox default value as today Textbox greyed out The following macro works fine until I share the workbook the I get "Requested shapes are locked for selection" '-2147024809(80070057)': This macro has worked for many years with ...
I am trying to sort and its greyed out?"},"Conversation:conversation:4209730":{"__typename":"Conversation","id":"conversation:4209730","solved":false,"topic":{"__ref":"ForumTopicMessage:message:4209730"},"lastPostingActivityTime":"2024-08-05T09:00:08.923-07:00","lastPostTime":"2024-...
Excel 2016 Desktop: Clear Filter & Reapply Filter Buttons are Disabled / Greyed out when Worksheet is Protected (but with permission Auto-filter turned on)When I turn on the Worksheet Protect:Then the Filter Clear and Reapply buttons are disabled? But they should not be as I allowed access ...
If a workbook structure is protected in Excel, you can tell because the insert, delete, etc. options will be greyed out when you right-click on a sheet tab. If access to the workbook is protected in Excel, then you will get a prompt to enter a password when you open it. You can ...
Right click a worksheet tab at the bottom of your screen and selectProtect Sheet…from the context menu. Or, click theProtect Sheetbutton on theReviewtab, in theChangesgroup. In theProtect Sheetdialog window, do the following: Topassword protect your Excel sheet, type a password in the corre...
I am trying to sort and its greyed out?","body@stringLength":"59","rawBody":" I am trying to sort and its greyed out?","kudosSumWeight":0,"repliesCount":4,"postTime":"2024-08-04T19:37:24.333-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount"...