---
title: "Restrict Updates, Inserts or Deletes"
slug: "designer-settings"
description: "Use Designer Settings to control whether users can insert, update or delete rows, set per SQL Server table loaded into Excel."
updated: 2026-10-21T11:46:11Z
published: 2026-10-21T11:46:11Z
canonical: "sqlspreads.com/designer-settings"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

#  Restrict Updates, Inserts or  Deletes

Designer Settings are configuration options that you can do per SQL Server table loaded into Excel.

![The Settings tab in the SQL Spreads Designer, with Allow delete rows, Allow insert new rows and Only allow inserting new rows](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%2856%29.png)

You find the Designer Setting in the right most **Settings** tab in the SQL Spreads Designer.

#### Allow Delete Rows

Uncheck the Allow Delete Rows to prevent users from being able to delete rows in the table.

#### Allow Insert new rows

Uncheck the Allow Insert new rows to prevent users from being able to insert new rows in the table.

#### Only allow inserting new rows

To only allow users to insert new rows, check the **Only allow inserting new rows** checkbox.

This setting will clear the spreadsheet after new rows have been saved to the database, and will prevent users from modifying or deleting any existing rows in the table.