How to create list for LibreOffice Calc cell (video)

Spreadsheet is a convenient tool to make calculations. But that's the not the only use the spreadsheets have now.

Many people use spreadsheets as a tool to exchange information. For example, you can get a spreadsheet from your supplier with request to list your order details there. On another side, you can create a similar spreadsheet to your customer, or even for household needs: keeping budget, or inviting friends to the party. The range of spreadsheets' use is large.

There are many cases when you want to help either yourself or another people with working with the spreadsheet you composed. For example, you want to advise that certain cells can only contain a pre-defined set of values and nothing else. The best way to do so is to give users a drop-down list to choose from.



The video in this post gives you a guidance how you can create the lists for certain cells in LibreOffice Calc. Similar instructions are valid for OpenOffice Calc too.

https://youtu.be/Q_uv9c_n7ns

Hope you enjoy! There are some other how-to videos you can check too.