How to Change Data in Excel

Changing data is one of the most fundamental tasks you'll perform in Excel. Whether you're correcting a single typo, updating thousands of product names, or reformatting entire columns of information, knowing the right way to make changes can save you hours of work. This tutorial will walk you through several methods for changing data in Excel, from simple cell edits to powerful bulk modifications.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Quick Edits: Changing Data in a Single Cell

Let's start with the basics. When you only need to change the contents of one cell, you have a few easy options. This is perfect for fixing a small mistake or updating a single piece of information.

Imagine you have a spreadsheet tracking sales, and you notice a customer's name is misspelled. Here's how to fix it:

1. Use the Formula Bar

The formula bar is the long input box located just above the column letters (A, B, C...). It displays the contents of the currently selected cell.

• Click once on the cell you want to edit (e.g., cell A2).
• Move your cursor up to the formula bar and click where you want to make your change.
• Make your edits and press Enter to confirm.

2. Double-Click the Cell

If you prefer to edit directly inside the cell, simply double-click it. This will place your cursor within the cell, allowing you to edit the text or number directly.

• Double-click the cell containing the data you want to change.
• Use your arrow keys or mouse to position the cursor.
• Type your changes and hit Enter.

3. Use the F2 Shortcut Key

For keyboard enthusiasts, the F2 key is the fastest way to edit a cell. It places your cursor at the end of the cell's current content, ready for you to start typing.

• Select the cell you need to modify by using your arrow keys or clicking on it.
• Press the F2 key on your keyboard.
• The cursor will appear at the end of the data in the cell. Make your changes and press Enter.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Bulk Changes: Using Find and Replace

When you need to change the same piece of data across multiple cells, rows, or even entire worksheets, manual editing isn't practical. This is where Excel's Find and Replace tool becomes your best friend. It can replace text, numbers, or even formatting instantly.

Let's say you're a marketer who just rebranded a service from "Basic Plan" to "Starter Plan." You have a spreadsheet with hundreds of rows referencing the old name. Here's how to update them all in seconds.

1. Open the Find and Replace tool by pressing Ctrl + H on your keyboard (or Cmd + H on a Mac). You can also find it on the Home tab under the "Find & Select" dropdown.
2. A dialog box will appear with two tabs: "Find" and "Replace." Make sure you are on the "Replace" tab.
3. In the "Find what:" field, type the data you want to change. In our example, you'd type "Basic Plan".
4. In the "Replace with:" field, type the new data. Here, you'd enter "Starter Plan".
5. Now, you have two choices:

Excel will then show you a confirmation message telling you how many replacements were made. Just like that, you've updated your entire dataset.

Advanced Find and Replace Options

For more control, you can click the "Options >>" button in the Find and Replace dialog box. This reveals powerful settings:

• Match case: Use this if the capitalization matters. For example, replacing "usa" but not "USA".
• Match entire cell contents: This ensures you are only replacing cells that contain exactly what you entered in "Find what:", and nothing else.

Non-Destructive Changes: Using Formulas to Modify Data

Sometimes, you don't want to change your original data directly. Instead, you might want to create a new, modified version of it in a separate column. This approach is non-destructive, meaning your source data remains untouched. It's a safer way to clean or reformat data, as you can always refer back to the original.

Excel offers several functions designed for manipulating text. Let's look at two of the most popular: `SUBSTITUTE` and `REPLACE`.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

1. The SUBSTITUTE Function

The `SUBSTITUTE` function is perfect for swapping out specific pieces of text within a cell. It works similarly to Find and Replace but as a formula.

The syntax is: `=SUBSTITUTE(text, old_text, new_text, [instance_num])`

• text: The cell containing the original data (e.g., A2).
• old_text: The specific text you want to get rid of (e.g., "-2023").
• new_text: The new text you want to put in its place (e.g., "-2024").
• [instance_num]: An optional argument telling Excel which occurrence to replace if there are multiples. If you leave it blank, it replaces all instances.

Example: Imagine column A contains Campaign IDs like "SummerSale-2023". You want to create updated IDs for the new year in column B.

1. In cell B2, you would type the formula:
2. Press Enter. Cell B2 will now display "SummerSale-2024".
3. To apply this to all your campaign IDs, just click on the small square (the fill handle) at the bottom-right corner of cell B2 and drag it down the column. Excel automatically applies the formula to each row.

2. Creating a Permanent Copy of Your Formula Results

Formulas are dynamic. If the data in your original cell (A2) changes, the formula result in B2 will update automatically. Often, you want to "lock in" the new values and get rid of the formulas.

Here's how to convert your formula column into static values:

1. Highlight the entire column containing your formulas (column B in our example).
2. Copy the selected cells (Ctrl + C or Cmd + C).
3. Right-click on the same selection (or a new column) and find the Paste Special options. Select Values. (The icon often looks like a clipboard with "123" on it).

This action replaces the formulas with their final calculated outputs. Your new data is now permanent and no longer linked to the original column. You can safely delete the original source column if you wish.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Rapid Formatting with Flash Fill

If you need to reformat data by extracting or combining it, Flash Fill is one of Excel's most impressive features. It automatically detects a pattern in what you're doing and completes the work for you.

Let's say you have a single column with full names ("John Smith"), and you need to create a new column with email addresses in the format "firstname.lastname@company.com".

1. In the cell next to your first full name (e.g., B2, next to A2 which contains "John Smith"), manually type the desired output: `john.smith@company.com`.
2. Press Enter.
3. Now, in the next cell down (B3), start typing the email for the next name. As soon as you type the first letter ("j" for "Jane Doe"), Excel's Flash Fill will instantly preview the rest of the column filled with correctly formatted emails.
4. If the preview looks correct, just hit Enter to accept it. That's it!

If the preview doesn't automatically appear, you can trigger Flash Fill manually. After typing your first example in B2, go to the Data tab and click on the Flash Fill button, or use the shortcut Ctrl + E.

Flash Fill is incredibly versatile and can be used for tasks like:

• Extracting first names from full names.
• Combining first and last names into a single column.
• Formatting phone numbers (e.g., adding dashes or parentheses).
• Pulling area codes or zip codes out of longer strings.

Final Thoughts

Knowing how to efficiently change data is fundamental to mastering Excel. From a simple double-click to fix a typo, to using Find and Replace for widespread updates, or applying formulas and Flash Fill for complex reformatting, these tools help you maintain clean, accurate, and usable data for your analysis and reporting needs.

While mastering Excel is incredibly valuable, a lot of this data manipulation is just the prep work needed before you can even begin analysis. We find that marketers and founders spend countless hours manually updating CSVs and fighting with spreadsheets just to build their weekly reports. This is precisely why we built Graphed. It automates the entire process by connecting directly to your tools like Shopify, Google Ads, or Salesforce. Instead of wrangling data in cells, you can just ask questions in plain English - like "show me my ad spend versus revenue this month" - and get a real-time, shareable dashboard instantly.