Define A Range Named Percent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C J - 07 Oct 2006 17:55 GMT

I am working on an Excel practice text and I have been asked to "Define a
range named percent to all the percent values in column E". Column E looks
like the following:
SAT Average
0.840935673
0.714285714
0.914634146
0.930232558

What do I do?

Thanks, CJ

Reply to this Message

Biff - 07 Oct 2006 19:44 GMT

Select the range E2:E4
In the name box (to the far left of the formula bar) you'll see where it
says: E2.
Click in that box and type: Percent
Hit ENTER

Now, check out the named range you just created.
Select any cell
Click the drop arrow in the name box
Click on Percent and see what happens

Biff

>I am working on an Excel practice text and I have been asked to "Define a
>range named percent to all the percent values in column E". Column E
[quoted text clipped - 8 lines]
>
> Thanks, CJ

Reply to this Message

C J - 08 Oct 2006 04:57 GMT

Thanks for your help.
CJ

> Select the range E2:E4
> In the name box (to the far left of the formula bar) you'll see where it
[quoted text clipped - 21 lines]
>>
>> Thanks, CJ

Reply to this Message

Biff - 08 Oct 2006 18:44 GMT

You're welcome!

Biff

> Thanks for your help.
> CJ
[quoted text clipped - 23 lines]
>>>
>>> Thanks, CJ

Reply to this Message