---
title: What Do I need to select when inserting/updating/deleting records?
description: Discover how you should select date when inserting/updating/deleting records.
---

[Skip to content](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#main-content)

English

Show submenu for translations

![Xappex-logo-with-name.png\]](https://knowledge.xappex.com/hs-fs/hubfs/Xappex-logo-with-name.png?height=40&name=Xappex-logo-with-name.png)

- [Products](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#products)
- [Blog](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#blog)
- [About](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#about)

Open main navigation

Close main navigation

- [Products](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#products)
- [Blog](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#blog)
- [About](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#about)
- English
  
  Show submenu for translations
- Go to xappex.com

 Go to xappex.com

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Xappex Knowledge Base](https://knowledge.xappex.com/?hsLang=en)
2. [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en)
3. [FAQs](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#faqs)

# What Do I need to select when inserting/updating/deleting records?

## Discover how you should select date when inserting/updating/deleting records.

The main thing to remember when performing Delete, Insert, Update, or Upsert operations is it only matters which rows of data your current selection spans across.

For example if you pulled a report on all the accounts and only want to update the first two, drag the selection rectangle so that any number of cells in the first two rows are selected (you may only select two cells, just make sure that these cells are located in different adjacent rows, if you select two cells in the same row, only one record will be updated).

Select Delete All/Insert All/Update All/Upsert All command to Delete/Insert/Update/Upsert all records in the spreadsheet. Be careful with this one though, these functions determine the used range using excel’s !UsedRange command, which is not always correct. Especially if you pulled a report and have some footer information at the bottom.

- [I use Google Sheets](https://knowledge.xappex.com/i-use-google-sheets?hsLang=en)
- [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#main-content)

    - [FAQs](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#faqs)
    - [I use XL-Connector](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector)
    - [I use XL-Connector 365](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector-365)
    - [I use Excel Merge package](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-excel-merge-package)
- [I use Looker Studio](https://knowledge.xappex.com/i-use-looker-studio?hsLang=en)

- [Products](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#products)
- [Blog](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#blog)
- [About](https://knowledge.xappex.com/what-do-i-need-to-select-when-inserting/updating/deleting-records#about)

[![Chill listening crop-3](https://knowledge.xappex.com/hubfs/Xappex-Logo.svg "Chill listening crop-3")](https://www.xappex.com)

xappex.com Help Center

Copyright © 2026, Xappex LLC