#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default Excel Templates

I downloaded a template I'd like to use for work. The problem is I need to
add more information to the drop down list that's built into the template.
It's a Nursing scheduling spreadsheet template. Can anyone help me?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Excel Templates

Is the dropdown a Validation dropdown? In that case you can add to the
list. Select the cell(s), choose Data/Validation, and modify the Source
appropriately.

In article ,
erica wrote:

I downloaded a template I'd like to use for work. The problem is I need to
add more information to the drop down list that's built into the template.
It's a Nursing scheduling spreadsheet template. Can anyone help me?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Excel Templates

Simplest way is to click the tab for the Data "sheet", r-click the
appropriate location and select Insert, then Shift Cells Down. Plug in
the info in the new Cell, then select and sort the cells in the column
if you wish.

erica wrote:

I downloaded a template I'd like to use for work. The problem is I need to
add more information to the drop down list that's built into the template.
It's a Nursing scheduling spreadsheet template. Can anyone help me?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Templates LCG Excel Discussion (Misc queries) 0 March 16th 06 07:49 PM
Excel is opening templates as templates instead of as worksheets Desram Setting up and Configuration of Excel 1 January 19th 06 09:38 PM
Excel Templates Danny Setting up and Configuration of Excel 3 December 1st 05 03:38 AM
Templates Excel XP sfrich1 Excel Discussion (Misc queries) 2 November 27th 05 07:23 PM
excel templates Tim Excel Discussion (Misc queries) 0 December 21st 04 04:39 PM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"