Editing Templates
 

I downloaded a template and would like to edit the selections in the a couple
of the drop down menus, especially for the menu the references employees who
will be working on a project and the categories. Thanks.

Editing Templates
 

Assuming the dropdowns are Data Validation List dropdowns, edit the source
range items and/or range reference.

You may have to unprotect the sheet in order to do this.


Gord Dibben MS Excel MVP

On Wed, 28 Jan 2009 08:31:02 -0800, Susan98
wrote:

I downloaded a template and would like to edit the selections in the a couple
of the drop down menus, especially for the menu the references employees who
will be working on a project and the categories. Thanks.

Editing Templates
 

We need more detail. If this is a Microsoft template tell us where you got
it. Also what type of drop downs are in the cells? Are these Form Combo
boxes, Control Toolbox combo boxes or a Data Validation List. If the drop
downs only display when you are in the cell you have a DV list.

To edit the last, select the cells where the drop downs are located and
choose Data, Validation, and change the Source range (or, heaven forbid -
edit the list in the Source box).
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Susan98" wrote:

I downloaded a template and would like to edit the selections in the a couple
of the drop down menus, especially for the menu the references employees who
will be working on a project and the categories. Thanks.