Hiding Rows and Columns in Microsoft Excel 2010

There are many reasons that we may need to hide different rows or columns especially for printing and distributing, but we also need to preserve the data that they contain.  It’s quite easy to do, just highlight the entire row(s) or column(s) that you would like to hide by clicking on the headings (1,2,3 or A,B,C). Now right click within the highlighted section and click Hide.  This will hide your selection until you Unhide it. To Unhide, look in the headings and place your cursor between the columns or rows that are hidden and right click, this time click Unhide.