Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
The Office Assistant has been a part of the Office landscape for several years now, and it still evokes strong reactions, just as it did when it was first introduced. Some people love the Office Assistant; others hate it.
If you are one of those who hates the Office Assistant, you may wonder how to best go about getting rid of it--permanently. The answer depends on the version of Office you are using.
When using Office 2003, you can turn off the Office Assistant so it doesn't pop up all the time by following these steps:
Now, the only time you will see the Office Assistant is if you choose Show the Office Assistant from the Help menu.
If you are using Excel 97, then you can use a different approach to get rid of the pesky characters. Follow these steps:
You can now restart any of your Office 97 programs (including Excel), and the Office Assistants are gone for good. If you later want them back, simply rename the folders back to Actors.
In later versions of Office, Microsoft did away with the Actors folder. Instead, you need to follow these steps:
Microsoft could certainly have made it easier to locate and move Office Assistant actor files by placing them all in a single folder, as they did in Office 97, but all in all it is not that difficult to locate them and move them.
Once done, you can restart your Office programs (including Word), and the Office Assistants are gone for good. If you later want them back, simply rename the folders back to Actors (Office 97) or move the ACS and ACG files back to their original locations (later versions of Office).
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3193) applies to Microsoft Excel versions: 97 2000 2002 2003
More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.