remove a drop-down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can I remove drop down lists in a workbook but keep the data in the cell?
 
When those are data validation lists (an activation button appears right to
active cell), then select the range with them, from Data menu select
Validation, and into Allow field select 'Any value'.


Arvi Laanemets


C Garrity said:
how can I remove drop down lists in a workbook but keep the data in the
cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top