Managing the User Interface

You can control or allow many types of behavior such as filtering, sorting, clipboard actions, grouping, selection, undo or redo, and many others. See the following topics for more information:

Using Automatic Fit
Using Clipboard Operations
Resizing Rows and Columns
Using Data Validation
Using Drag and Move
Using Drag Fill
Using Edit Mode Always
Using Formulas
Freezing Columns and Rows
Using Input Mapping
Using Keyboard Navigation
Creating Multiple Headers
Using Protect and Cell Locking
Using Range Grouping
Filtering Rows
Using Scroll Bars
Working with Selections
Using Shrink to Fit
Creating Tables
Using the TabStrip
Displaying Tooltips
Using Undo and Redo
Creating Viewports
Allowing Zooming