ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to remove list option (https://www.excelbanter.com/excel-discussion-misc-queries/163122-how-remove-list-option.html)

VIVEKMANE

how to remove list option
 
hi i have seleted a data and put into the list, now i have to remove the list

how do i do??????

Kevin B

how to remove list option
 
Reselect your list range and click DATA in the menu, select LIST and then
select CONVERT TO RANGE. In the following confirmation dialog box click YES
to convert the list back to a normal range.
--
Kevin Backmann


"VIVEKMANE" wrote:

hi i have seleted a data and put into the list, now i have to remove the list

how do i do??????


claude jerry

how to remove list option
 
Follow the same steps you did to put the data in the list and do just the
opposite

"VIVEKMANE" wrote:

hi i have seleted a data and put into the list, now i have to remove the list

how do i do??????



All times are GMT +1. The time now is 01:52 AM.

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