How to use advanced sorting options in Excel. ... Then, click the Options button to launch the dialog shown in Figure A. (You must select a range of values to access these settings.) ...

Menu options being grayed out in Microsoft Excel is quite common. Some menu options go grayed or unavailable when editing a cell in your worksheet. In that case, you must press the Enter button to ...

Press Win+R to display the Run dialog. Type regedit > press the OK button > click on the Yes button. Go to Microsoft\office\16.0 in HKCU. Right-click on 0 > New > Key and name it as excel. Right ...