Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
Cooking Tips
ExcelTips (menu)
ExcelTips (ribbon)
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
School Tips
Wedding Tips
WordTips (menu)
WordTips (ribbon)

Advertise on the
ExcelTips Site

Newest Tips

Automatically Protecting After Input

Sorting Data on Protected Worksheets

Sorting with Graphics

Understanding Manual Calculation

Using Color in Headers and Footers

Moving a Chart's Legend

Quickly Updating Values

 

Adjusting Picture Appearance

Summary: Using the Picture toolbar in Excel to easily adjust the appearance of a graphic in a workbook. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel users can quickly and easily adjust the appearance of a picture once it is placed in a workbook. Adjustments are accomplished the easiest if you are using the Picture toolbar. This toolbar should become visible when you click on a graphic. If it does not, you can right-click on the graphic and choose Show Picture Toolbar from the Context menu.

The toolbar has several tools on it that control the appearance of the selected graphic. These tools include the following:

  • Image Control. This tool presents a menu of options you can use to specify how the graphic should be treated, i.e., as a black and white drawing or as a grayscale image.
  • More Contrast. Increases the contrast between light and dark in the image.
  • Less Contrast. Decreases the contrast between light and dark.
  • More Brightness. Turns up the overall brightness of the image.
  • Less Brightness. Makes the image more dark, overall.

In order to use the adjustment tools, simply click on them. (When using the Image Control tool you will need to select an option from a menu first.) Remember that if you mess things up you can always click on the Undo tool on the regular Excel toolbar. If you mess things up too bad, you can click on the Reset Picture tool on the Picture toolbar. This sets you image back to its pre-change settings.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1998) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.
 
Check out ExcelTips: Custom Formats today!