Cell I8 on the Dashboard style report, is a list of all the months, years or date range. To create this list first define all the content that you want within the drop down in a selection of cells. Once you have done this select the cell that you to have the dropdown be contained in and then set the list by… |
1. Go to the "Data" tab, and select "Data validation"… |
2. Then a pop should appear, then select "List" from the dropdown. |
3. Then select the source field, this should then close up the box then select the data that you would like to appear within the list. |
4. Once you have done this it should reopen the screen, and look a little like the below. |
5. If you would like to add a note to the cell, select the "Input message" tab, add a heading, and content then select ok |
6. And you have now created a nice simple list. Done!! |
Friday 21 May 2010
Dashboard style report - How to create a list?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment