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...

Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 There are different ways to scroll through a worksheet. You can use the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet. In Excel, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and ScreenTips that let you know where you are in the worksheet. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars. When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off. To do that, press the Scroll Lock key (labeled as ScrLk) on your keyboard. If your keyboard doesn't include this key, you can turn off SCROLL LOCK by using the On-Screen Keyboard. To open the O...