You may have a worksheet that contains some sensitive information that you don’t want to see on a print out. You can create “Custom Views” to make it easier to display only the information that you want seen.
In this example we have a Worksheet used by Human Resources, it contains a list of employees. This sheet contains salary information and Social Security numbers. It also has a column that lists the employees phone extension and I want to print the sheet for the department heads so they have an updated phone list. I don’t want them to see the sensitive information and I don’t want to delete the existing columns. I am going to create two custom views so that I can go back and forth easily from displaying all the information in the sheet, to only displaying the information that can be made public.  This process will work the same in Excel 2010 and Excel 2007.