Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Assigning a Macro to a Keyboard Combination

Creating Scenarios

Using Message Boxes

Understanding Phantom Macros

Picking a Group of Cells

Running Out of Memory

Hiding Rows Based on a Cell Value

 

Large Toolbar Buttons

Summary: You can configure Excel so that it uses large toolbar buttons on its toolbars. This can make the interface easier to use if the buttons normally appear too small for your tastes. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

If the toolbar buttons on your screen are too small for your liking, you may want to make them larger. Excel makes this easy--all you need to do is follow these steps:

  1. Choose the Customize option from the Tools menu.
  2. Display the Options tab. (Click here to see a related figure.)
  3. Make sure the Large Icons check box is selected.
  4. Click on the Close button.

You should have noticed that your toolbar buttons were much larger right after step 3. This action also affects the size of toolbar buttons in all your other Microsoft Office applications, as well.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2067) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.
 
Check out ExcelTips: Serioius Sorting today!