How to create a nested drop-down list in Excel If you want to obtain data from some existing drop-down menus or cells and display options accordingly in a different cell, here is what you can do.

How to Change the Color Coding on a Microsoft Excel Graph Legend. Color can make it easier for people to identify important information, such as legends on an Excel graph.

Open the Name Manager by going to Formulas > Name Manager. Create a named range using the `GET.CELL` formula. For example, enter `=GET.CELL (63, A1)` to retrieve the background color code of cell A1.