Hiding lines, or rows, in Microsoft Office Excel 2010 is very simple: Right-click the lines and select "Hide." However, expanding the hidden lines in the Excel spreadsheet is not as simple.

Removing hidden metadata information from a Microsoft Excel spreadsheet is not difficult if you follow the steps laid out here.

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.