ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add data to drop down lists? (https://www.excelbanter.com/excel-worksheet-functions/105591-how-do-i-add-data-drop-down-lists.html)

Rosi59

How do I add data to drop down lists?
 
I have two linked worksheets and I am trying to update the drop down menu by
adding an entry. How do I do this. I am totally new at this and flying by
the seat of my pants without a manual (which we all know may look like it's
written in an understandable language but isn't anyway!) Thanks

Marcelo

How do I add data to drop down lists?
 
hi,

right click at the drop down box and chose format controls

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rosi59" escreveu:

I have two linked worksheets and I am trying to update the drop down menu by
adding an entry. How do I do this. I am totally new at this and flying by
the seat of my pants without a manual (which we all know may look like it's
written in an understandable language but isn't anyway!) Thanks



All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com