Ads by Google

Sunday, September 27, 2009

Comment Box Shapes and Picture

Bored with the same rectangle yellow comment boxes on your file? Here is a way to change them to shapes of your choice with picture on it (I am Using Excel 2007)

  1. Select the cell with the comment
  2. Press Shift+F2 to edit the comment box
  3. Select any border of the comment box. You will notice that the box line has full of dots now.
  4. Right click and select Format comment
  5. Select "Color and Lines" tab
  6. Now select "Fill effects" from the color drop down


  7. Now from the Picture tab, select a picture from your local drive and add it to the comment box.
  8. Now the background of your comment box changes to the picture you have selected


  9. Before you proceed to change the shape of this comment box, make sure that you have "Change Shape" toolbar activated in the "Quick Access Toolbar". To do this, follow these steps:
    1. Select Office button on the top
    2. Select Excel Options
    3. Select Customize option and select All command from the drop down on the top of this window.
    4. Scroll down till you find "Change Shape" command. Add it to the Quick Access toolbar but selecting it and clicking on Add button


    5. Once you are done with it, you will be able to locate "Change shape" icon on the top left near the office button.


  10. Follow Steps 1 to 3
  11. Select a shape from the "Change Shape" options (remember which we added just now).
  12. You will notice that the comment box shape is changed now.



 

No comments: