in Excel 2010 you are able to hide the worksheets by right clicking on them and selecting hide.
For part of a worksheet, you can hide all columns and rows that you do not wish to be seen by highlighting the columns/rows, again right clicking the selected rows/columns and then selecting hide.
To make hidden parts "permanent" you can simply protected the workbook.