Teach Yourself MS Office 2003 In 24 Hours Free Open Book

Teach Yourself MS Office 2003 In 24 Hours

Previous Section Next Section

Adding Comments

You can insert comments in cells. The comments act like yellow sticky notes onscreen, except that the notes in Excel aren't in the way when you don't want to see them. The comments don't appear in the cell; when you insert a comment, Excel indicates that the comment resides within the cell by flagging the cell's upper-right corner with a red triangle. When you point to the cell, Excel displays the attached comment.

To attach a comment to a selected cell, select Insert, Comment or right-click over a cell and select Insert Comment. Excel opens the box shown in Figure 8.7. Type your comment in the box and press Enter. Excel automatically places your name at the beginning of the comment (assuming that you entered your name when you installed Office). The name indicates who added the comment in case you work in a multiple-user environment. (You can erase the name if you don't want to see it.) You can leave co-workers notes if you edit worksheets as a team. You can also leave yourself a note to fill in data that you might get from an outside source later.

Figure 8.7. Comments help document the worksheet cells.

graphics/08fig07.jpg

graphics/alarmclock_icon.gif

If you select a group of cells and attach a comment, Excel attaches the comment only to the upper-left cell in the selection. Excel cannot attach a comment to an entire selection, only to individual cells.


The section "Clearing Data" earlier in this hour tells you how to remove comments you no longer need.

    Previous Section Next Section
    Index: [SYMBOL][A][B][C][D][E][F][G][H][I][J][L][M][N][O][P][Q][R][S][T][U][V][W][X][Z]


         Main Menu
    Main Page
    Table of content
    Copyright
    About the Author
    Acknowledgments
    We Want to Hear from You!
    Introduction
    Part I: Working with Office 2003
    Part II: Processing with 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
    AutoCorrect Worksheets
    Reviewing Cut, Copy, and Paste in Excel
    Clearing Data
    Speed Data Entry
    Smarter Fills with AutoFill
    Designing Your Own Fills
    A Word About Printing
    Adding Comments
    Summary
    Q&A
    Hour 9. Formatting Worksheets to Look Great
    Hour 10. Charting with Excel 2003
    Part IV: Presenting with Flair
    Part V: Organizing with Outlook 2003
    Part VI: Tracking with Access 2003
    Part VII: Combining Office 2003 and the Internet
    Part VIII: Publishing Eye-Catching Documents
    Part IX: Appendixes
    Part X: Bonus Hours
    Index


    More Books
    PHP Hacks
    Processing Xml With Java - A Guide To Sax, Dom, Jdom, Jaxp, And Trax
    The Koran (Holy Qur'an)
    Macromedia Flash 8 Bible
    Search Engine Optimization for Dummies
    YouTube Traffic
    PHP 5 for Dummies
    Harry Potter and The Chamber of Secrets
    Harry Potter and the Sorcerer's Stone
    The Pilgrim's Progress
    Wireless Hacks
    Flash Hacks. 100 Industrial-Strength Tips & Tools
    PayPal Hacks. 100 Industrial-Strength Tips and Tools
    Amazon Hacks
    Pdf Hacks
    The Da Vinci Code
    Google Hacks
    The Holy Bible
    Windows XP For Dummies
    Harry Potter and the Half-Blood Prince
    Seo Book
    Upgrading and Repairing Networks
    Macromedia Dreamweaver 8 UNLEASHED
    Windows XP Annoyances
    Windows XP Hacks
    Microsoft Windows XP Power Toolkit
    Teach Yourself MS Office In 24Hours
    iPod & iTunes Missing Manual
    PC Hacks 100 Industrial-Strength Tips and Tools
    PC Overclocking, Optimization, and Tuning - 2th Edition
    PC Hardware In A Nutshell 3rd Edition
    PC Hardware in a Nutshell, 2nd Edition
    Upgrading and Repairing PCs
    Google for Dummies
    MySQL Cookbook
    Teach Yourself Macromedia Flash 8 In 24 Hours
    PHP CookBook
    Sams Teach Yourself JavaScript in 24 Hours
    PHP5 Manual
    Free Games Paper Airplanes
    500 Juegos Gratis 500 Giochi Gratis 500 Jeux Gratuits 500 Jogos Gratis 500 Kostenlose Spiele