Microsoft Excel 2007 with Example

1 Introduction

1.4 Hide Columns or Rows

Hide Unhide 

Sometimes it can be useful to hide columns or rows in Excel.

Hide

To hide a column, execute the following steps.

1. Select a column.

Hide Column Example

2. Right click, and then click Hide.

Click Hide

Result:

Hide Column Result

Note: to hide a row, select a row, right click, and then click Hide.

Unhide

To unhide a column, execute the following steps.

1. Select the columns on either side of the hidden column.

Unhide Column Example

2. Right click, and then click Unhide.

Click Unhide

Result:

Unhide Column Result

Note: to unhide a row, select the rows on either side of the hidden row, right click, and then click Unhide.