AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Excel Template
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
Mark@Northern Iowa
Posted 5/8/2021 22:34 (#8994892 - in reply to #8993475)
Subject: RE: Excel Template

Floyd County, Iowa
I use Excel 2007, hopefully your version isn't to much different
If you are looking at the example that Robert posted, I can explain from it.
He used Data Validation. Look at the pictures that I posted.
My picture Data Validation 1
- select cell A2
- select data validation tab
- select data validation, and it brings up the popup menu
as you can see, for cell A2 the source for his dropdown is pre typed in as the source
My picture Data Validation 2
With this picture i tried to show you how to do data validation with data pre typed into cells.
I pre typed the data into cells G2 through G6
- select data validation, and it brings up the popup menu
- select list
- select source box
- click cell G2, drag to G6, and release the mouse button
- select OK
Now when you select that cell, you have drop down choices from cell data
I am also uploading the changes I made to Roberts example.
Any questions, don't hesitate to ask
Have a good day

Edited by Mark@Northern Iowa 5/8/2021 22:37

(Data Validation 1 (full).jpg)

(Data Validation 2 (full).jpg)

Attachments Data Validation 1 (full).jpg (98KB - 15 downloads)
Attachments Data Validation 2 (full).jpg (61KB - 15 downloads)
Attachments Data Validation example.xlsx (9KB - 22 downloads)
Top of the page Bottom of the page

Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)