Prev: Vlookup
Next: fraction into date
From: ikeym on 2 Feb 2010 18:35
I have an expence templae for excel made by someone else.I need to know how
to change/create the category names from a drop down list.Any help
appreciated.
From: Gord Dibben on 2 Feb 2010 19:07
A Data Validation dropdown?

Select the cell with the dropdown and Data>Validation.

See what the source is for the list.

It could be a comma-delimited list or a range of cells or a defined name
like =MyList

Alter that source list.


Gord Dibben MS Excel MVP

On Tue, 2 Feb 2010 15:35:01 -0800, ikeym <ikeym(a)discussions.microsoft.com>
wrote:

>I have an expence templae for excel made by someone else.I need to know how
>to change/create the category names from a drop down list.Any help
>appreciated.

 | 
Pages: 1
Prev: Vlookup
Next: fraction into date