Microsoft Excel :

Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. Microsoft Excel with a Microsoft 365 subscription is the latest version of Excel. Previous versions include “Excel 2016, Excel 2013, Excel 2010, Excel 2007, & Excel 2003”. By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed. Excel contains a large number of boxes called cells that are ordered in rows and columns. Working knowledge of Excel is vital for most office-based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities.

How to add the dropdowns in Excel?

  • Open the Microsoft Excel.
  • Prepare the template as per your veiw.
  • Select the cells where you need the drop-down list.
  • Select Data Validation under the Data.
  • Select List which you make it ready for the dropdown.
  • Enter the values for your drop-down list.
  • Click OK.
  • Completed!!

 

Categorized in: