# Row or Column Insert or Delete Dialogs

Learn how to add or remove rows and columns in a spreadsheet using Spread Designer. Right-click to access the Insert or Delete dialog and make changes effortlessly.

## Content

You can add or remove rows and columns from the sheet using the Spread Designer. Select a row or column on the spreadsheet to indicate where to insert the rows or columns, or select the rows and columns to remove. To open this dialog, right-click on the row or column, and select **Insert** to add rows or columns or **Delete** to remove rows or columns. The figure below shows each of the the dialogs that can be brought up. Type in the number to insert and click **OK**.
![Insert Row Dialog](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/sd-dialog-insertrows.png)

For more information on the addition or removal of rows or columns, refer to [Adding a Row or Column](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcoladd) and [Removing a Row or Column](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolremove) in the Developer’s Guide. For more details on how to do this in code, refer to the various methods in the [SheetView](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.html) class.

## See Also

[Cell Type Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog)
[Conditional Formatting Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDconditionalDialog)
[Custom File Options Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCustomFileOptions)
[Go To Cell Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDGoToCell)
[Row Height or Column Width Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDHeightWidth)
[Shape Properties Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/sdshapepropsdialog)
[Shape Shadow Properties Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDShapeShadowDialog)
[Sheet Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSheetDialog)
[Sheet Print Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDPrintDialog)
[Sort Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSortDialog)
[Spread Settings Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDSpreadDialog)
[Unhide Specific Row or Column Dialogs](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDUnhideDialog)
[Zoom Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDZoomDialog)
[BarCode Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog/SD-celltype-barcode)
[Color Picker Tab](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDCellTypesDialog/sd-celltype-colorpicker)
[Name Manager Dialog](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-dialogs/SDNameManager)