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.
    

    
    

 

Get rid of GETPIVOTDATA Option

If you want to disable the Generate GetPivotData setting, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Excel 2003

1. On the Tools menu, click Customize.
   
2. Click the Toolbars tab, and then click to select the PivotTable check box. The PivotTable toolbar is displayed.
   
3. Click Close.
   
4. On the PivotTable toolbar, click the Toolbar Options arrow. This arrow appears on the right end of the toolbar.
   
5. Click Add or Remove Buttons, click PivotTable, and then select Generate GetPivotData.
   
6. Click in the worksheet.
   
7. Click the Generate GetPivotData button that now appears on the PivotTable toolbar. When you click this button, it is turned on or off. If the button is selected, the GETPIVOTDATA formula is automatically generated.
   

Excel 2007

1. Click the Microsoft Office Button, click Excel Options, and then click the Formulas tab.
   
2. Make sure that the Use GetPivotData functions for PivotTable references check box is selected, and then click OK.
   
3. Click in the worksheet.
   
4. Click the Options tab, click Options in the PivotTable group, and then click to clear the Generate GetPivotData check box.