---
title: How To Add A Column From an Example In Microsoft Excel
description: How To Add A Column From an Example In Microsoft Excel
image: https://blog.360smartnetworks.com/hubfs/Imported_Blog_Media/GettyImages-881365070.jpg
---

[![360 Smart Networks Logo - Technology Solutions For Business](https://blog.360smartnetworks.com/hs-fs/hubfs/360%20Smart%20Networks%20(with%20BG)%20RGB-01.png?width=869&height=300&name=360%20Smart%20Networks%20(with%20BG)%20RGB-01.png "360 Smart Networks Logo - Technology Solutions For Business")](https://www.360smartnetworks.com/)

Open main menu Close main menu

[techbytes](https://blog.360smartnetworks.com/blog/tag/techbytes) [360 Smart Networks Business Tech Insights](https://blog.360smartnetworks.com/blog/tag/blog)

# How To Add A Column From an Example In Microsoft Excel

[Marius Nel](https://blog.360smartnetworks.com/blog/author/ulisticadmin)

[Share this blog post on Twitter](https://twitter.com/intent/tweet?text=I+found+this+interesting+blog+post&url=https://blog.360smartnetworks.com/blog/how-to-add-a-column-from-an-example-in-microsoft-excel) [Share this blog post on Facebook](http://www.facebook.com/share.php?u=https://blog.360smartnetworks.com/blog/how-to-add-a-column-from-an-example-in-microsoft-excel) [Share this blog post on LinkedIn](http://www.linkedin.com/shareArticle?mini=true&url=https://blog.360smartnetworks.com/blog/how-to-add-a-column-from-an-example-in-microsoft-excel)

![](https://blog.360smartnetworks.com/hubfs/Imported_Blog_Media/GettyImages-881365070.jpg)

<span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce\_SELRES\_start"></span> Microsoft Excel has been around for ages. However, did you know that there are a whole host of functionality features to simplify your workflow and help you save time? One of the most commonly used tools is the  *Add Column from Example* option. Here’s what you need to know about it.

**How Do You Add a Column from an Example in Microsoft Excel?**

Start by selecting *Query > Edit*. Then select *Add a Column*. Choose *Column from Examples* and *From All Columns*. After a column is populated, go ahead and add sample data for the new column. Press the *Ctrl + Enter* keys to instruct Excel to populate the remaining fields.

**When is Adding a Column from an Example in Microsoft Excel Useful?**

The Add Column from Example feature is an instrumental part of Microsoft Excel’s Power Query functionality that saves users an immense amount of time. Examples of an ideal time to use this function in situations where you need a column that references another column, such as when you want to join two columns together. For example, combining city and state names together for an address.

![Microsoft Excel](https://blog.360smartnetworks.com/hs-fs/hubfs/Imported_Blog_Media/GettyImages-881365070.jpg?width=508&height=339&name=GettyImages-881365070.jpg)

**Is Add Column from Example a Feature for All Versions of Microsoft Excel?**

Unfortunately, the Power Query feature of Microsoft Excel is a relatively new addition to the popular software program. You must have Excel 2016 or Office 360 to use it unless you install a free add-in from [Microsoft](https://www.microsoft.com/en-au/download/details.aspx?id=39379) to your version,

In short, the *Add Column from Example* feature is a practical and useful way to clean up data sets without additional time or effort.

### Leave a Comment

## Related Articles

[![](https://blog.360smartnetworks.com/hubfs/Imported_Blog_Media/GettyImages-949203034.jpg)](https://blog.360smartnetworks.com/blog/ransomware-explained)

[securitybytes](https://blog.360smartnetworks.com/blog/tag/securitybytes) [360 Smart Networks Business Tech Insights](https://blog.360smartnetworks.com/blog/tag/blog)

### [Ransomware Explained](https://blog.360smartnetworks.com/blog/ransomware-explained)

Ransomware. Ransomware. You have heard the word and know it involves a cyberattack. You assume from news reports that it only happens to large companies like Target,...

[Marius Nel](https://blog.360smartnetworks.com/blog/author/ulisticadmin) 

[Read More](https://blog.360smartnetworks.com/blog/ransomware-explained)

[![](https://blog.360smartnetworks.com/hubfs/Imported_Blog_Media/Let-Your-Ideas-Flow___.jpg)](https://blog.360smartnetworks.com/blog/how-does-using-microsoft-digital-ink-improve-workplace-collaboration)

[techbytes](https://blog.360smartnetworks.com/blog/tag/techbytes) [360 Smart Networks Business Tech Insights](https://blog.360smartnetworks.com/blog/tag/blog)

### [How Does Using Microsoft Digital Ink Improve Workplace Collaboration?](https://blog.360smartnetworks.com/blog/how-does-using-microsoft-digital-ink-improve-workplace-collaboration)

The integration of the Microsoft (MS) digital ink function and digital pen provides companies with a way to improve collaboration, increase out-the-box creativity, and...

[Marius Nel](https://blog.360smartnetworks.com/blog/author/ulisticadmin) 

[Read More](https://blog.360smartnetworks.com/blog/how-does-using-microsoft-digital-ink-improve-workplace-collaboration)

#### About

- Menu Item One
- Menu Item Two
- Menu Item Three

#### Services

- Menu Item One
- Menu Item Two
- Menu Item Three

#### News

- Menu Item One
- Menu Item Two
- Menu Item Three

Follow us on Facebook Follow us on LinkedIn Follow us on Twitter Follow us on Instagram

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Marius Nel",
    "url" : "https://blog.360smartnetworks.com/blog/author/ulisticadmin"
  },
  "dateModified" : "2022-10-28T09:02:55.137Z",
  "datePublished" : "2019-01-11T18:06:00.000Z",
  "headline" : "How To Add A Column From an Example In Microsoft Excel",
  "image" : [ "https://blog.360smartnetworks.com/hubfs/Imported_Blog_Media/GettyImages-881365070.jpg" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.360smartnetworks.com/blog/how-to-add-a-column-from-an-example-in-microsoft-excel",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.360smartnetworks.com/hubfs/360%20Smart%20Networks%20(with%20BG)%20RGB-01.png"
    },
    "name" : "360 Smart Networks"
  }
}
```