Datasheet

Customize the Quick Access Toolbar .................................................................................. 4
Customize the Ribbon ............................................................................................................ 6
Export Ribbon Customizations to a File ............................................................................10
Configure Excel to Use the Mouse Wheel for Zooming .................................................12
Move in a Different Direction When You Press Enter .....................................................14
Automatically Insert a Decimal Point ................................................................................16
Configure When Excel Warns You About Long Operations ...........................................18
Pin Excel to the Windows 7 Taskbar..................................................................................20
Make a Workbook Faster by Saving it as Binary .............................................................22
Open a New Window for a Workbook .............................................................................24
Allow Only Certain Values in a Cell ...................................................................................26
Apply Text or Formatting to Multiple Worksheets ..........................................................28
Quickly Display the Office Clipboard ................................................................................ 30
Use Dialog Box Controls to Input Data .............................................................................32
Check for Accessibility Problems ....................................................................................... 36
03_577769-ch01.indd 303_577769-ch01.indd 3 3/27/10 9:00 AM3/27/10 9:00 AM