Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
editing excel templates | New Users to Excel | |||
Templates | Excel Discussion (Misc queries) | |||
Excel is opening templates as templates instead of as worksheets | Setting up and Configuration of Excel | |||
ROI Templates | Excel Discussion (Misc queries) | |||
templates | Excel Worksheet Functions |