In Excel 2007, what would be the easiest way to create "buttons" that hide and/or unhide certain rows? I have a spreadsheet with several hundred rows of data in multiple columns that all relate together with various formulas. From this data are several views I want to be able to obtain with the click of a mouse. The views involve nothing other than hiding some rows and unhiding others. The best scenario would be to have designated cells at the top of the spreadsheet, each of which corresponds to a specific view and each of which, when clicked, would produce that view. Is there a way to do that? I was thinking it might be possible with a macro or maybe by using the Filter function. Would either of those work or is there a simpler solution?