Did you know you can make a drop down list for selecting an item with just a right click? Yep!

I never really noticed it, but there’s an option in the right click menu to Pick From Drop-down List.

This can be handy if you’re doing a one off data entry and will allow you to enter some data exactly as it appears in cells above to avoid any typos.

Right-Click-Cell-Underneath-Data Right Click for a Drop Down List

To use this, select an empty cell directly underneath your data and right click.

Right-Click-Menu-Pick-from-Drop-Down-List Right Click for a Drop Down List

From the resulting menu select the Pick From Drop-down List option.

One-Off-Drop-Down-List Right Click for a Drop Down List

Now you have a one time use drop down list to select from based on all the data directly above.