Thoroughly research any product advertised on the sites before you decide to download and install it. Watch out for ads on the sites that may advertise products frequently classified as a PUP (Potentially Unwanted Products). The pages appear to be providing accurate, safe information. Standard Disclaimer: There are links to non-Microsoft websites. Then all the ribbon and quick access toolbar customizations will be deleted. Click Customize Ribbon, then click the small triangle besides Reset to open the drop-down list menu. In the registry editor dialog, select HKEYCURRENTUSER -> Software -> Microsoft -> office -> 16.0 -> word. From your keyboard, press Windows + R and typing the keyword regedit, click OK or press enter button. Click Options at the bottom of the left side bar. For this tutorial, I will restore default settings in Word, other software, you can do the same way. If you don't have any more questions, feel free to choose a rating and let us know whether this information was helpful to you!" First, switch to File tab in the new file. Under General options there is a section for When. You can then repeat this process for other Office applications.įeel free to ask back any questions and let me know how it goes. 2: Changing the Default Font for New Workbooks Click on the File tab. Save the file as book.xlt in the excel system startup folder. This will restore the menu to its original settings.Ĭonsequently, restoring all the menus will restore Microsoft Excel to its defaults. Changing the default is done in the following way: Create a new Excel document in which all default settings are set. Right-click the menu you want to restore and then click the "Reset" button. Then click Next after selecting Delimited. Select Text to Columns from the drop-down menu. To go to the Textto Columns wizard, go to the Data tab (optional). Hi, my name is Nigel and I am an Independent Advisor here to try and work with you on this issue you are having.Ĭlick on the "Tools" menu and then click "Customize.". Microsoft Excel (method 1) On your PC, open Microsoft Excel.