• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

simple excel question

S

Spooner

Lifer
i don't know why i don't know this, but how do you input selection criteria into a cell in Excel?

Like if I'm making a tracking sheet for where documents are and i want someone to be able to select either Doc A or Doc B when filling in a row, how do I do that?
 
you mean like a drop down list?

type 'enter data in a cell from a list you specify' in Excel help and there is a howto section on how it's done.
 
click data
click validation
choose list from the listbox
type in what you want in the list separated by a comma.
click ok.
viola, you got a listbox
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top