Pages

Friday 21 May 2010

Dashboard style report - How to create a list?

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!!

No comments:

Post a Comment