{"id":5788,"date":"2021-05-20T08:46:13","date_gmt":"2021-05-20T08:46:13","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=5788"},"modified":"2024-03-28T10:34:33","modified_gmt":"2024-03-28T10:34:33","slug":"remove-dropdown-list","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/remove-dropdown-list\/","title":{"rendered":"Remove Dropdown List in Excel"},"content":{"rendered":"\n
More times than I could think of in my life I have been asked a question from one of my business colleagues on how to remove or type something else in an Excel cell that has limited options- options being a range of cells, a list of options, or anything else.<\/p>\n\n\n\n
Typically, these \u201cproblematic\u201d cells are formed as a so-called dropdown list, so the problem can be easily solved by removing this list. We are going to show you how to do it.<\/p>\n\n\n\n
To understand how to remove a Dropdown<\/strong> list<\/strong> in Excel, we first have to understand how to create one.<\/p>\n\n\n\n Let’s assume that we have a cell A1<\/strong> into which we type simply Name<\/strong>. In cell B1<\/strong> we want to limit our options for the name and to choose from Jessica, Hank, or Mark (a random list of names).<\/p>\n\n\n\n To do this, we have to type these names into the computer’s memory. For this example, we will type them into column K<\/strong> (into cells K1<\/strong>, K2<\/strong>, and K3<\/strong>).<\/p>\n\n\n\n