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

formating

ResolvedVersion 2003

Gerard has attended:
Excel Introduction course

Formating

how do you format a 3D fomular?

RE: Formating

Hi Gerard, Thank you for your question:

It is not normal to format a formula, you would normally format the result of the formula, and to do this you select the cell/s and then on the Menu bar got to Format>Cells and from the tabs choose the formatting you wish to apply.
If however you mean how do you create a 3D formula:
Select the cell you wish to have the result appear in, press the = key on your keyboard and then navigate to the worksheet/workbook to find the cell you wish to link to, select it and press Enter. I hope that helps ... Pete

Wed 10 Dec 2008: Automatically marked as resolved.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.