Not quite sure what you are asking.




Let me elaborate on what I'm doing. It's extremely simple and basic.

I've created two databases with Access. One is flat-file, one is
relational.

They are movie collection databases. Nothing fancy.

But I want (for various reasons) a stripped-down list of my movies in
spreadsheet form.

The only three columns in the spreadsheet will be:

Title
Genre
Location

There will be only 20 genre items, i.e. drama, comedy, foreign,
mystery, etc.

I want some semblance of consistent data entry. For example, I don't
want to enter sience fction [sic] by accident.

Furthermore, there will be only eight Location items.

I do *not* like auto-complete, so I was looking for a way to
streamline the Genre and Location selection process. I figured a
drop-down menu would be the easiest way.

In Access, there is a feature called a Lookup Table. It's a table
with pre-entered items, with which you can build a drop-down menu,
called a Combo Box. This ensures consistent data entry, and also
makes it easier to add new items to the list. You simply add new
things to the Lookup Table.

Basically, I want the same thing in Excel, if possible. Apparently,
it is.

However, I want to configure an entire column so that each cell in
that column will have a drop-down menu, rather than right-click each
and every cell.

From what I've read in this thread, something similar to a Lookup
table is possible, and having a drop-down menu in each cell of a
column is possible. I just have to try it, which I will do soon.

That's basically all I want. I hope this clarifies things further.