Hide and Unhide Columns and Rows in Excel

In addition to adding and removing columns and rows it is also possible to hide them in an Excel spreadsheet.

Say you need to printout a worksheet, but you only want parts of it - columns A, B, C, and F for example.

By hiding columns D and E you stop them from being printed - and maybe get your printout to fit on a single page.

Even when hidden, formulas continue to work and hidden data can be referenced by formulas and functions in other parts of the spreadsheet.

Read this series of articles to find out all the details on how to Hide and Unhide Columns and Rows in Excel.

Related Articles

• Excel 2007 Formatting Tutorial
• Parts of the Excel 2007 Screen
• Parts of the Excel Screen