ITCanopy

Select the cells or Column where you want to add the drop down list.  Go to Data tab and click on Data Validation.   In dialog set List in Allow field. Now in Source field select the excel sheet and then cells (using cursor select the cell range) which have the drop down values. Click OK. Now check the cell. It will have the drop down arrow and on clicking it will display the values.

Microsoft Office is a commonly-used, proprietary office suite. Because the Microsoft Office suite is designed for Microsoft Windows, it cannot be installed directly onto a computer running Ubuntu. However, it is possible to install and run certain versions of Office using the  WINE  Windows-compatibility layer available in Ubuntu. WINE is available only for the Intel/x86 platform. Alternatively, Ubuntu offers a wide range of high-quality office software, some of which is compatible with the Microsoft Office file formats. Notably,  LibreOffice  is Ubuntu's default office suite and is installed/available on all platforms supported by Ubuntu. A brief guide to the office software available in Ubuntu can be found on the  OfficeApplications  page. The following guide gives instructions on how to install and run Microsoft Office on Ubuntu by using WINE. Checking if your version of Office is supported by WINE This guide assumes that you have a copy o...