FlexSheet for WPF | ComponentOne
Working with C1FlexSheet / Sheet Operations / Inserting and Deleting Rows and Columns
In This Topic
    Inserting and Deleting Rows and Columns
    In This Topic

    Inserting and deleting rows and columns is really easy in FlexSheet for WPF. The context menu of C1FlexSheet consists of the options to Insert Rows, Delete Rows, Insert Columns, Delete Columns and other clipboard options. These options are members of the ContextMenuCommands enum.

    Context menu

    To insert a row, follow the given steps:

    1. Right-click on a row or a cell. To insert multiple rows, you need to select multiple rows and then do the right-click operation.
      A context menu appears with the list of options.
    2. Select Insert Rows option from the context menu.
      The number of row(s) inserted will be equal to the number of selected rows.

    To delete a row, follow the given steps:

    1. Right-click on a row or a cell. You need to select multiple rows and then do the right-click operation to delete them.
      A context menu appears with the list of options.
    2. Select Delete Rows option from the context menu.
      The selected row(s) will be deleted.

    Similarly, you can insert and delete columns by choosing Insert Columns and Delete Columns options from the C1FlexSheet context menu.