To hide cells in Excel 2010, first identify the row or column you want to hide. With the row or column highlighted, select Format, Visibility and Hide Rows or Hide Columns.Continue Reading
On the Excel spreadsheet in which you are working, select the part of the worksheet you want to hide. Do this by placing the cursor on the number of the row or the letter of the column, then click. Be certain that the row or column turns blue. Drag the cursor to the right or left, or even up or down, to select a group of rows or columns to hide.
Click the Home tab, usually located next to the File tab, to access the formatting options.
Look for the Format button in the Cells section of the bar. It is typically located next to Insert and Delete.
Find the Visibility heading under the Cell Size heading.
Use the mouse to select Hide and Unhide directly under the Visibility heading. This opens another menu.
In the new menu, select either Hide Rows or Hide Columns to hide the blue rows or columns. Note that this menu is also where you "unhide" the rows or columns.