auto format

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Auto format

Auto format

resolvedResolved · Low Priority · Version 2003

Andrew has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Advanced course

Auto format

how do i use auto format?

RE: auto format

Hello Andrew

Thank you for your question and welcome to the forum.

To use Autoformat:
1. Select the cells that you wish to format.
2. Go to Format - AutoFormat.
3. Select the formatting you wish to apply from the samples shown, and click OK.

The AutoFormat you chose will be applied to the cells you selected.

Amanda


 

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips


Server loaded in 0.08 secs.