#1
|
|||
|
|||
excel2016: can't create dropdown
I'm trying to create a dropdown from a named range in a diffrent sheet, and get some wierd erros, please help.. the dropdown is in the cells on column F and the names range is "Worksheet 1: A1:A4" |
#2
|
|||
|
|||
Maybe like shown in the attached.
|
#3
|
|||
|
|||
yes. but how you did it? I tried but failed..
|
#4
|
|||
|
|||
Changed name of present sheet Worksheet 1 to Sheet1
Inserted a new sheet and named it Sheet2 In Sheet2!A1 I inserted the following formula: =INDEX('רשימת עובדים להעלאה'!$A$1:$X$1;COLUMNS('רשימת עובדים להעלאה'!A1:$A$1)) Copied this formula to A1:X1. Selected Sheet2!A1:X1, took a copy and pasted to the same range as values. Deleted sheet רשימת עובדים להעלאה. Selected Sheet2!F2, Data, Data Validation, List and selected Sheet1!A1:A4. (=family_status). OK. Don't ask me about the very strange behaviour of sheet רשימת עובדים להעלאה. I wonder if it may have been set up by someone reading from right to left?? |
#5
|
|||
|
|||
it's in hebrew so yes, it was in rtl, not sure why that would be a problem..
I'll try the steps you described to find out what was the problem.. I'll update what I found |
Tags |
drop down lists, excel 2016, named range |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ActiveX is not activated when opening Excel2016 sheet | Pierrot | Excel Programming | 0 | 10-28-2016 03:33 AM |
how to create a special template to create a clear lay out for plain text | hex | Word | 1 | 04-01-2016 09:58 AM |
Mail merge from excel - need to create sheets and create a table | bluenosebex | Mail Merge | 5 | 08-02-2015 05:34 PM |
Hovertext on dropdown | NGilbert | Word | 1 | 07-03-2014 06:57 AM |
Need help populating dropdown box | antztaylor | Word | 3 | 11-06-2012 05:46 PM |