User Interface Reference > Spreadsheet > Columns and Rows

The Spreadsheet provides the capability to display and hide columns and rows in a worksheet.

Hide and Unhide Columns

1.Select the column to be hidden.

2.Do one of the following:

oSet the column width to zero. To do this, drag the boundary of the column heading until the column is hidden;

oOn the Home tab, in the Cells group, click the Format button and select Hide & Unhide | Hide Columns;

oRight-click the selected column and select the Hide item from the context menu.

3.To show the column you hid, select the columns adjoining to either side of the hidden column, and then do one of the following:

oOn the Home tab, in the Cells group, click the Format button, and then select Hide & Unhide | Unhide Columns;

oRight-click the selected columns and select the Unhide item from the context menu.

1.Select the row to be hidden.

2.Do one of the following:

oSet the row height to zero. To do this, drag the boundary of the row heading until the row is not displayed;

oOn the Home tab, in the Cells group, click the Format button and select Hide & Unhide | Hide Rows;

oRight-click the selected row and select the Hide item from the context menu.

3.To display the row you hid, select the rows that are above and below the hidden row, and then do one of the following:

oOn the Home tab, in the Cells group, click the Format button, and then select Hide & Unhide | Unhide Rows;

oRight-click the selected rows and select the Unhide item from the context menu;

1.Click the Select all button at the intersection of the column and row headings, or press CTRL+A.

2.Do one of the following:

oOn the Home tab, in the Cells group, click the Format button, and then select Hide & Unhide | Unhide Rows or Unhide Columns;

oRight-click the selection and select the Unhide item from the context menu.

Send Feedback on this topic to DevExpress.