General Tips on Excel

If you navigate a lot within a worksheet, between worksheets, between spreadsheets or between Microsoft applications, use the hyperlink (Globe and broken chain on the "Standard" toolbar). You can attach a link to an empty cell, a datum in a cell, any  image, "WordArt" object or elements offered on the "Design" toolbar. Select the object or the cell, click on the "Globe" and create the external or internal link.

Drop-down lists without macros (VBA)

Select a cell or a group of cells, go to the menu bar Data/Validation, select "List" in the "Allow" window and submit a list of values or a range of cells in the "Source" window. The range containing the list of values must be on the same worksheet as the drop-down list. Is there a way around this limit? YES YES YES. The range containing the values can be anywhere.