Sams Teach Yourself Microsoft Office 2003 in 24 Hours
- Table of Contents
- Copyright
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Introduction
- Who Should Read This Book?
- What This Book Does for You
- Can This Book Really Teach Office 2003 in 24 Hours?
- Conventions Used in This Book
- Part I. Working with Office 2003
- Hour 1. Getting Acquainted with Office 2003
- Part II. Processing with Word 2003
- Hour 2. Welcome to Word 2003
- Hour 3. Formatting with Word 2003
- Hour 4. Managing Documents and Customizing Word 2003
- Hour 5. Advanced Word 2003
- Part III. Computing with Excel 2003
- Hour 6. Understanding Excel 2003 Workbooks
- Hour 7. Restructuring and Editing Excel 2003 Worksheets
- Hour 8. Using Excel 2003
- Hour 9. Formatting Worksheets to Look Great
- Hour 10. Charting with Excel 2003
- Part IV. Presenting with Flair
- Hour 11. PowerPoint 2003 Presentations
- Hour 12. Editing and Arranging Your Presentations
- Hour 13. PowerPoint 2003 Advanced Features
- Hour 14. Animating Your Presentations
- Part V. Organizing with Outlook 2003
- Hour 15. Communicating with Outlook 2003
- Hour 16. Planning and Scheduling with Outlook 2003
- Part VI. Tracking with Access 2003
- Hour 17. Access 2003 Basics
- Hour 18. Entering and Displaying Access 2003 Data
- Hour 19. Retrieving Your Data
- Hour 20. Reporting with Access 2003
- Part VII. Combining Office 2003 and the Internet
- Hour 21. Office 2003 and the Internet
- Hour 22. Creating Web Content with Word, Excel, Access, and PowerPoint
- Part VIII. Publishing Eye-Catching Documents
- Hour 23. Publishing with Flair Using Publisher 2003
- Hour 24. Adding Art to Your Publications
- Part IX. Appendixes
- Appendix B. Business Contact Manager and Office Extras
- Part X. Bonus Hours
- Hour 25. Using FrontPage 2003 for Web Page Design and Creation
- Hour 26. Managing Your Web with FrontPage
Clearing Data
Because of the nature of worksheets, erasing worksheet data differs from erasing word-processed data. Other information on the worksheet can heavily depend on the erased data, as you saw in the previous hour's lesson. When you want to erase a cell's or selection's contents, first decide which of the following kinds of erasure you want to perform:
- Erase the selection and send the contents to the Clipboard (as you learned in the previous section).
- Clear only a portion of the selection, such as its formatting, comment, or contents.
- Completely erase the selection and all formatting and notes attached to the selection.
- Erase the selected cells and their positions so that other cells in the row move left or cells below move up.
If you want to delete only the selected cell's data, press Delete. Excel retains any formatting and comments that you had applied before you deleted the data.
If you want to more selectively erase a cell, select the Edit, Clear command and select from one of the four options listed here:
- The All option deletes the entire selection, including the contents, format, and attached comments (but not the actual cell).
- The Formats option erases only the selection's format; you can get rid of a cell's special formatting and revert to a general format without changing or erasing the actual contents of the cell.
- The Contents option deletes the cell data but leaves the formatting and comments intact.
- The Comments option deletes any special comments that appear in the selected cells.
To remove the selected cells as well as their contents and close the gap left by the deleted selection, select Edit, Delete to display the Delete dialog box, as shown in Figure 8.3. Select Shift Cells Left or Shift Cells Up so that Excel knows how to close the gap that the deletion leaves.
)
Figure 8.3 You can delete cells and move all other cells over those deleted cells.
Speed Data Entry | Next Section
Account Sign In
View your cart