How to Delete a Column in Tableau

Trying to clean up your Tableau worksheet by removing a column but can't find a simple delete button? You’re not alone. Tableau thinks about charts and data differently than a spreadsheet, so removing a column isn’t always as straightforward as right-clicking and hitting delete. This guide will walk you through the correct ways to remove columns from your visualizations, hide them to tidy up your workspace, and permanently delete them when necessary.

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

Why You Can't Just "Delete" a Column in a Tableau Worksheet

In a tool like Excel or Google Sheets, your data and your visualization are one and the same - a grid of cells. Deleting a column there removes the data from that grid in a very direct way. Tableau separates your data from your visualization. Your raw data lives in the "Data Pane" on the left, and your worksheet is a canvas where you visualize that data.

Think of it like cooking. Your Data Pane is your pantry, filled with all your raw ingredients (your data columns). Your worksheet is the recipe you are building. The fields you drag onto the "Columns" and "Rows" shelves are the ingredients you’ve chosen for that specific dish.

When you want to remove a column from your chart, you aren't deleting the ingredient from your pantry, you're simply taking it out of the recipe. The ingredient is still available in the pantry if you want to use it later. Deleting a column permanently, however, is like throwing that ingredient out for good - a much more final action that we’ll cover later.

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

How to Remove a Column From Your Tableau Visualization

This is the most common task and likely what you're trying to do. You have a visualization - like a table or a bar chart - and you want to remove one of the data columns being displayed. There are a couple of incredibly simple ways to do this.

Let's imagine you're a marketing manager looking at a bar chart that shows Website Sessions by Source and Campaign. The chart feels too crowded, and you decide you just want to see the total sessions by Source.

Method 1: Drag and Drop

The drag-and-drop method is the most intuitive way to manipulate your view in Tableau. It’s a physical representation of taking an element out of your visualization.

• Step 1: Locate the pill on the "Columns" or "Rows" shelf that represents the column you want to remove. In our example, this would be the Campaign pill.
• Step 2: Click and hold the pill. A small icon will appear under your cursor.
• Step 3: Drag the pill off the shelf and back into the Data Pane on the left. The "remove" icon (a gray X) will appear as you drag.
• Step 4: Release the mouse button. The pill will vanish from the shelf, and your visualization will instantly update to remove that dimension. Your chart will now correctly show total sessions by Source.

Method 2: Right-Click and Remove

If you prefer using menus over dragging, this method is just as fast.

• Step 1: Find the pill on the "Columns" or "Rows" shelf you wish to remove (e.g., the Campaign pill).
• Step 2: Right-click on the pill to open the context menu.
• Step 3: Select Remove from the options.

Just like with the drag-and-drop approach, the pill will disappear and your chart will immediately update. In both cases, the Campaign field is still available in your Data Pane if you change your mind and want to add it back.

Should You Hide a Column Instead of Deleting It?

Sometimes, your goal isn't to remove a column from a specific chart but to clean up your workspace. Your data source might have dozens or even hundreds of columns, many of which you'll never use. They can cause clutter and make it harder to find the fields you actually need. In this situation, hiding the column is often a better choice than deleting it.

When you hide a column, it disappears from the Data Pane, but it's not gone for good. Tableau still knows it exists, so any calculations or worksheets that rely on it will continue to work perfectly. This is a safe, reversible way to tidy up.

When to Hide a Column

• Clutter Removal: The most common reason is to hide fields you know are irrelevant to your current analysis (e.g., system IDs, notes fields, or redundant data).
• Intermediate Calculations: You may have created a calculated field that is only used inside another, more complex calculation. You can hide the intermediate one to avoid confusion.
• Preventing Misuse: If your dataset has two similar fields, like Sub_Total and Final_Price, you might hide one to ensure your team consistently uses the correct one.

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

How to Hide (and Show) a Column

Hiding a field is incredibly simple and done directly in the Data Pane.

1. Navigate to the Data Pane on the left side of your worksheet.
2. Find the field you want to hide.
3. Right-click on the field name.
4. Select Hide from the context menu.

The field will now disappear from the list. To see it again, click the small dropdown arrow at the top of the Data Pane (next to the search bar) and select Show Hidden Fields. The hidden fields will reappear, grayed out. Right-click on any of them and choose Unhide to bring them back permanently.

When and How to Permanently Delete a Column

Permanent deletion is the "nuclear option." This action removes the column from Tableau’s understanding of the data source for this specific workbook. Be careful: this action cannot be undone with a simple Ctrl+Z. If any of your worksheets, dashboards, or calculated fields are using that column, they will break.

Important Note: Deleting a column in Tableau does not affect your original data file. If your source is an Excel file, that file will remain untouched. This action only applies to the data connection within your Tableau workbook.

When Is Permanent Deletion a Good Idea?

• Performance: If you're working with a massive dataset, columns with high cardinality (many unique values) or text-heavy fields can slow down your workbook. Removing them can improve performance.
• Data Sensitivity: The column contains personally identifiable information (PII) or other sensitive data that should not be included in the workbook before you share it.
• Irrelevant Data: The column is entirely useless for any analysis and is just taking up space. For example, a column full of null values or placeholder text.

How to Permanently Delete a Column from Your Data Source

You cannot delete a column from the worksheet view. You must go to the Data Source tab.

1. At the bottom-left of the Tableau window, click the Data Source tab.
2. You’ll see a spreadsheet-like preview of your data at the bottom of the screen.
3. Find the column you want to delete. Hover your mouse over the column name.
4. Click the small downward-facing arrow that appears on the right side of the column header.
5. Select Delete from the menu.

Tableau will remove the column from the data model. Before doing this, it’s a good practice to use the "dependency" feature. Right-click any column in the Data Pane and select "Describe." This can sometimes help show if the field is being used elsewhere, so you can avoid breaking your dashboards by mistake.

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

Using Filters for More Control

Lastly, it's worth considering if what you really want to do is filter your data, not remove a column. Sometimes a user asks "how do I delete a column?" when they actually mean "how do I remove some of the data shown by this column?"

For instance, let’s say you have a Country column in a sales chart. You only want to see data for USA, Canada, and Mexico. You don't want to get rid of the Country column entirely, just focus on a specific segment.

In this case, a filter is the perfect tool:

1. Drag the Country pill from the Data Pane onto the Filters card.
2. A dialog box will pop up, listing all the countries in your dataset.
3. Check the boxes for USA, Canada, and Mexico.
4. Click OK.

Your visualization will now only show data for those three countries, but the underlying Country column remains part of your chart's structure. Filters are flexible, interactive, and non-destructive - a powerful way to refine your analysis without removing structural elements.

Final Thoughts

Mastering column management in Tableau means understanding the difference between modifying a visualization, hiding fields for clarity, and permanently deleting data from your model. Removing pills from the shelves is a daily, risk-free task, while permanently deleting columns is a less common action that requires a bit more caution. Using these methods, you can keep your worksheets and data sources perfectly organized for effective analysis.

Learning the intricacies of tools like Tableau is valuable, but it often involves navigating complex menus just to get a straightforward answer. At Graphed, we've designed a platform that bypasses this learning curve. Instead of dragging pills or hunting for the 'delete' option, you can create reports using simple language like, "Show me last quarter's sales by region, but exclude the West." If you'd rather spend your time acting on insights instead of building reports, take a look at what you can build with Graphed.