How can I create a sheet for each row in Excel?

Instead of typing in the name in the box as done in selton's example, you can use "Data Validation" cell to create an in-cell dropdown. Go to Data -> Validation -> Allow "List", and for "Source" point it at the full list of student names. This ensures that the vlookup criteria will always be an exact match. Instead of typing in the student's name, you can just pick it out of the full list.

The quick-and-dirty way I know of (which would be clunky and time-consuming, but would do what you want: 1. Highlight the rows you want to hide. 2. Go to "Format", then "Rows," then click "Hide." 3. Ta-da. You can then get back to the all-info sheet by highlighting everything, going to "format" then "rows" and then "unhide."

Failing that, is there some method I haven't thought of that will easily black out every row but one (or possibly two, including the top row of assignment labels)? Conditional formatting. Columns: Name | gradestuff | show? When show? is blank, gradestuff is black text with a black background. When you put a 1 or true or whatever in it, it's black text with a white background. http://www.cpearson.com/excel/cformatting.htm

When you put a 1 or true or whatever in show?*

The easiest way to do something like that would be to create a mail merge document in Microsoft Word using the data from the Excel sheet.

If the filter forces you to select at least one (I can't remember right now if it does), either create a fake student and keep that one selected and add the real student to the filter, or make the selection while the student can't see the screen. Filter is Ctrl-Shift-L (or under the "Sort and Filter" dropdown).

Yeah, if you're using excel 2003, then click on column with the students' names in it so it's all highlighted, then click "Data", then "Filter", then "AutoFilter". Now there should be a little arrow in that column. Click that arrow and scroll down to the student's name, and click on it. You should see only the row with that student's name in it. To go back, click on the little arrow and scroll to the top and click (All).

Oh, and if you want to keep the top assignments row there the whole time, highlight the row immediately beneath it, then click "Window" then "Freeze Panes" now when you do the filter thing that top row should stay visible. And it will also stay visible when scrolling down when you're viewing all the rows.

I think I'd create another sheet for when you want to show the students their grades and keep your full listing as it is. This example uses the vlookup function and it brings through the various grades according to the name that's typed into the grey box on the 'search' sheet, there's probably more than 5 subjects so the formula under 'ENG', 'MATH' etc. would need to be copied across. https://docs.google.com/spreadsheet/ccc?key=0AiQgCxNxmzxBdFlWb3o5aHhPZjl2YmxhNG1Tc3Y1SFE