New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Start learning with our library of video tutorials taught by experts. Get started

Excel 2010 Essential Training
Illustration by

Inserting and editing comments


From:

Excel 2010 Essential Training

with Bob Flisser

Video: Inserting and editing comments

Comments in Excel is a great feature that a lot of people don't know about. Comments are like yellow sticky notes where you can jot down info for yourself, or maybe for anyone else who uses the workbook, which is why you'll find Comments under the Review tab. And what's really cool is that comments don't have to look like yellow stickies. Now, in this worksheet here I have some comments and they're all ready. I might need to scroll down. You see we have these three cells with red triangles in the upper-right corner. That's how you know that there are comments in those cells. Just roll your mouse pointer over it.
Expand all | Collapse all
  1. 1m 35s
    1. Welcome
      57s
    2. Using the exercise files
      38s
  2. 19m 31s
    1. Exploring three common uses for Excel
      3m 17s
    2. Touring the interface
      3m 38s
    3. Finding the commands you need
      3m 51s
    4. Using Backstage view or the File tab
      3m 25s
    5. Maintaining file compatibility
      5m 20s
  3. 21m 23s
    1. Creating a worksheet
      5m 23s
    2. Techniques for copying and pasting
      3m 57s
    3. Entering data automatically with Auto Fill
      4m 37s
    4. Targeting large data groups
      4m 26s
    5. Changing a worksheet's structure
      3m 0s
  4. 47m 50s
    1. Understanding formulas and functions
      4m 41s
    2. Entering data in a worksheet
      3m 22s
    3. Adding numbers manually
      5m 1s
    4. Adding numbers using Sum and AutoSum
      6m 11s
    5. Adding a whole worksheet
      1m 48s
    6. Working with numbers in columns
      4m 53s
    7. Preventing errors using absolute references
      5m 57s
    8. Working with times and dates
      3m 8s
    9. Using IF
      4m 49s
    10. Using SUMIF and AVERAGEIF
      4m 15s
    11. Naming and using cell ranges
      3m 45s
  5. 33m 57s
    1. Formatting numbers and dates
      7m 6s
    2. Applying fonts, background colors, and borders
      4m 35s
    3. Adjusting columns, rows, and text
      5m 2s
    4. Using conditional formatting
      4m 6s
    5. Using custom conditional formatting
      5m 49s
    6. Adding pictures and shapes
      7m 19s
  6. 25m 27s
    1. Inserting SmartArt
      6m 54s
    2. Coordinating a look using themes
      3m 22s
    3. Applying built-in styles
      3m 16s
    4. Creating and sharing styles
      5m 33s
    5. Using templates
      4m 9s
    6. Creating and using original templates
      2m 13s
  7. 13m 23s
    1. Making the pieces fit
      4m 57s
    2. Inserting headers and footers
      3m 51s
    3. Printing and PDFs
      4m 35s
  8. 34m 3s
    1. Finding and replacing data
      3m 12s
    2. Freezing panes
      3m 0s
    3. Repeating row and column titles
      3m 34s
    4. Creating multiple custom worksheet views
      5m 18s
    5. Hiding or grouping rows and columns
      5m 31s
    6. Managing worksheets
      7m 23s
    7. Calculating formulas across worksheets
      6m 5s
  9. 36m 34s
    1. Importing and exporting data in Excel
      8m 2s
    2. Setting workbook permissions
      6m 44s
    3. Inserting and editing comments
      6m 49s
    4. Sharing a workbook
      1m 25s
    5. Tracking changes
      3m 5s
    6. Saving files in shared locations
      10m 29s
  10. 27m 30s
    1. Splitting cell data into multiple cells
      2m 22s
    2. Joining data from multiple cells
      4m 18s
    3. Basic and multi-field sorting
      6m 30s
    4. Using tables to sort and filter data
      4m 31s
    5. Inserting automatic subtotals
      3m 46s
    6. Creating lookup tables
      6m 3s
  11. 32m 56s
    1. Using auditing to diagram
      6m 3s
    2. Using evaluation in Excel
      2m 2s
    3. Working with Goal Seek
      5m 29s
    4. Using data tables in formulas
      6m 2s
    5. Using scenarios in formulas
      5m 28s
    6. Exploring the Analysis Toolpak
      7m 52s
  12. 18m 1s
    1. Discovering PivotTables
      2m 22s
    2. Creating a basic PivotTable
      2m 46s
    3. Modifying a PivotTable
      6m 57s
    4. Creating and modifying a PivotChart
      5m 56s
  13. 26m 58s
    1. Choosing chart types
      1m 55s
    2. Inserting Sparklines
      3m 54s
    3. Creating a column chart
      3m 23s
    4. Modifying a column chart
      5m 47s
    5. Creating and modifying a pie chart
      6m 45s
    6. Placing Excel charts into other Office applications
      5m 14s
  14. 21m 53s
    1. Understanding macros
      3m 5s
    2. Recording and using a simple macro
      11m 58s
    3. Editing a macro
      6m 50s
  15. 20m 33s
    1. Customizing the Quick Access toolbar
      3m 30s
    2. Customizing the Ribbon bar
      8m 44s
    3. Setting Excel options
      8m 19s
  16. 16s
    1. Goodbye
      16s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Excel 2010 Essential Training
6h 21m Beginner Jun 09, 2010

Viewers: in countries Watching now:

In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Topics include:
  • Copying and pasting techniques
  • Working with formulas and functions
  • Dealing with formula errors
  • Creating lookup tables
  • Naming cell ranges
  • Formatting data and worksheets
  • Finding and replacing data
  • Creating SmartArt diagrams
  • Creating charts and PivotTables
  • Recording macros
  • Sharing workbooks
Subjects:
Business Computer Skills (Windows) Spreadsheets Teacher Tools Education Student Tools
Software:
Excel
Author:
Bob Flisser

Inserting and editing comments

Comments in Excel is a great feature that a lot of people don't know about. Comments are like yellow sticky notes where you can jot down info for yourself, or maybe for anyone else who uses the workbook, which is why you'll find Comments under the Review tab. And what's really cool is that comments don't have to look like yellow stickies. Now, in this worksheet here I have some comments and they're all ready. I might need to scroll down. You see we have these three cells with red triangles in the upper-right corner. That's how you know that there are comments in those cells. Just roll your mouse pointer over it.

So, here's a regular comment. It looks like a yellow sticky. Here's a comment. It doesn't look anything like the yellow sticky. And here's a comment that actually has an image in it. And I'm going to show you how to do all three of those. So, maybe let's scroll up. First, let's talk about inserting a plain old comment. Click any cell here, and go up to the Review tab, and to insert a comment you can click the New Comment button. And it should show up with your name or whatever is the name that's registered on this computer, and maybe let's type in "This is a new product." And to deselect, just click anywhere else on the sheet. It goes away.

Now, you have that red triangle, roll your mouse over, and the comment shows up. Another way to insert a comment is click a cell, and you can press Shift+F2. And just type in "This is another comment," and again, just click off it. What if you want to edit a comment that already exists? Well, click the cell itself, and now instead of New Comment, the button is changed to Edit Comment. And maybe we don't want this comment, so to delete it just click on the border of the comment and press Delete.

Another way to edit, click a cell that has a comment and the same shortcut, Shift+F2, and enter the comment, and again, click off it to deselect. Well, what if you have a lot of comments on the sheet and you want to read them in order one after another? I'll just click up at the top of the sheet here and still under the Comments section you see we have Previous and Next buttons. Click Next. And every time you click Next, it opens up the comment and click Previous, it opens the previous comment, and I'll just click off here.

So, how do we make these comments not look like yellow stickies? Well, click the cell that has a comment you just edited. And we could either Edit Comment or Shift+F2. And right-click the shaded border, and from the pop-up menu choose Format Comment. And we're in the Format Comment dialog box, and you want to be in the Colors and Lines tab. And under Fill, first of all let's choose a different color. Maybe I'll choose something that's a little bit more olive-y and maybe I want a dark green.

And let's change the font and I'll choose a font that's maybe a little different. I'll choose Franklin Gothic, and I wanted that to be white so I'll be able to read it, and I'll make it bold. Click OK and there you go. Deselect if you want, roll your mouse pointer over it, and it's a plain text comment, but it doesn't look like a yellow sticky. So, let's change the shape. Well, before we change the shape, we have to do a little bit of customization to Excel. Now, later on in the course I'll be talking about how to customize the Ribbon bar here and how to customize the Quick Access toolbar, but we have to do a little preview here just so that we can change the shape of the comment.

Here's what you do. Click the Insert tab, click Shapes, choose any shape. It doesn't matter what shape it is, because we're going to delete it in a few seconds. Click Shape, somewhere over here out of the way just draw the shape, and see this puts you in the Drawing tools section and the Format tab. And over here on the left you see it says Edit Shape? Click that, choose Change Shape, and choose any other shape, and the shape that you drew will now change. Well, what we want to do is go back to that Edit Shape, roll over the Change Shape, and click your right mouse button on it, and choose Add to Quick Access Toolbar, and that gets added up here.

So, now anytime you want to change shape, you can click that and choose another shape and it changes. So, we don't need this anymore. The only reason we put this shape on the worksheet was so that we can customize the Quick Access toolbar. So just select it and delete it. Well, here's where we use it with the comment. Click that cell that has a comment you want to change, go to the Review tab, and Edit Comment or press Shift+F2 if you like. Click the border of the comment, and now up here on the Quick Access toolbar click Change Shape, and now choose any other shape and there you go.

And you can stretch it out if you need to. Click off it and now when you roll back on it, now there is your new shape. Okay, that's great. What about inserting an image? Click on this Multi-Pack 1 up here and again insert a comment. Press Shift+F2 or click New Comment. And let's just delete any text that you have in there. Put your mouse pointer on the border of the comment, right-click, choose Format Comment from the pop-up, and in the Format Comment dialog box, let's again go over here to Colors and Lines. And under Fill, click the drop-down.

Down over here choose Fill Effects. And in the Fill Effects dialog box click the Picture tab and then over here click Select Picture. Now, in the Chapter 8 folder of the Exercise Files, we have this Multi-Pack 1. Double-click it and it inserts it. Click OK. And if you don't want a line to show up, you can just click that and choose No Line. Click OK and there you go. Click off it. Roll your mouse over it and you can get a better look. We could change the shape of that also. Click back on the cell and either Shift+F2 or click Edit Comment.

Now, you don't see it, but don't worry, it hasn't been removed. Click the border of the comment, you can see the picture again, click the Change Shape button, and let's choose another shape. Stretch it if you need to, click off it, and when you roll back on, there is the picture and the new shape. Okay, that's great. Just a few other features of comments I want to tell you about. What if you want to print comments out? Well, first of all up here in the Comments section you see where it says Show All Comments, click that, and click off it. So that's where you can display or hide comments. Well, click turn it on, go to your File tab and Print, or you could press Ctrl+P. And you see the comments aren't there. You have to go and make them print out.

Down on the bottom, click the Page Setup link. In the Page Setup dialog box, click the Sheet tab and over here where it says Comments are None, click that and choose As displayed on sheet. Click OK and they will print just the way they are in the sheet. Another option, if you click on Page Setup you may have noticed in the Sheet tab, if you don't want them to display on the sheet itself you could choose At end of sheet and your comments will simply print out on the separate page. But even if you don't share your Excel sheets with other people, I'm sure you'll still find comments handy to use just for yourself.

There are currently no FAQs about Excel 2010 Essential Training.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Excel 2010 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.