Nokia C3: Settings for resetting the excel menus

Settings for resetting the excel menus
I had endeavor a macro commencing from this site to add alternatives to the right hit it off menu in excel. At present when I right hit it off on any workbook within excel I have comprised these menu options and I not be able to acquire rid of them. As well as this I am missing a number of alternatives from the customary drop down menus. ie set print area and clear print area disappeared totally. I have managed to locate them by resetting, then customizing the menu and re-adding them - other than the freeze/ unfreeze panes alternative commencing from the windows menu has disappeared totally and are not even on the customize menu. Need some help is there a method to restore the whole thing back to default settings?
Reply With Quote
#2
Old 04-07-2011
Nymphs Nymphs is offline
Member

Join Date: Mar 2010
Posts: 268
Re: Settings for resetting the excel menus
The Office programs have encompassed a characteristic called "Personalized Menus and Toolbars". This characteristic is shared across the entire Office programs. The "Personalized Menus and Toolbars" characteristic appraise what menu commands you utilize and displays merely those items to facilitate are utilized most regularly on a shortened version or description of each menu. By defaulting, when you hit it off a menu and rest the mouse pointer in excess of the menu title, the menu enlarges to display the entire menu items. The menu expands merely if the demonstrate full menus subsequent to a short delay alternative is selected.
Reply With Quote
#3
Old 04-07-2011
Erinyes Erinyes is offline
Member

Join Date: Mar 2010
Posts: 308
Re: Settings for resetting the excel menus
Correspondingly, toolbars intelligently share space on the screen, pedestal on the toolbar buttons with the intention of you utilize the majority regularly. As a result, toolbar buttons are promoted or demoted (displayed or hidden), pedestal on a hierarchy with the intention of facilitates multiple toolbars to share a single row. When you hit it off the slider button (>>) on a toolbar, the absolute toolbar is hurriedly displayed. Subsequent to you hit it off a specific toolbar button, with the intention of button is added to the visible portion of the toolbar.
Reply With Quote
#4
Old 04-07-2011
Muses Muses is offline
Member

Join Date: Mar 2010
Posts: 282
Re: Settings for resetting the excel menus
On the View menu, position to Toolbars, and then you have to hit it off Customize. Then after that on the Options tab, hit it off Reset my usage data. Subsequent to that againg you have to hit it off Yes to the following message. This determine to eliminate the record of the commands you have utilized in this application and restore the defaulting set of visible commands to the menus and toolbars. It determine to not undo several explicit customizations. Are you certain you desire to do this and Click Close to close the Customize dialog box.
Reply With Quote
#5
Old 04-07-2011
Asclepius Asclepius is offline
Member

Join Date: Mar 2010
Posts: 311
Re: Settings for resetting the excel menus
Here you have to rename the Program PIP File than you have to right hit it off on the Start and then click Explore on the shortcut menu. Then after that you have to browse to the folder with the intention of is particular in the "Where Are Personalized Menus and Toolbar Settings Saved" segment of this article. Then you have to right hit it off the program PIP file for which you desire to reset menu usage, and then click Rename on the shortcut menu. Then you have to rename it and ENTER. Documents and Settings//Application Data/Microsoft/Office. If you rename these program defaulting PIP files (not suggested), the Office program endeavors to reconfigure itself through the Windows Installer program, and moreover of the following might occur.
Reply With Quote
#6
Old 04-07-2011
Tamkinat Tamkinat is offline
Member

Join Date: Apr 2010
Posts: 242
Re: Settings for resetting the excel menus
If you hit it off OK to this error message, the installer program backs out of its revolutionize and attempt to mechanically configure the program the entire in excess off again. To permit the Office program to appropriately organize itself, place the Office CD-ROM in the CD-ROM drive, and then hit it off OK. To permit the Office program to appropriately configure itself, place the Office CD-ROM in the CD-ROM drive, and then hit it off OK to the error message. You have to hit it off OK in the dialog box with the intention of is requesting the Office CD-ROM. How to Turn Off the "Personalized Menus and Toolbars" characteristic.
Reply With Quote