If you opened an old workbook, locate the sheet with the dataset in it. After you create a new workbook, type or copy and paste your dataset into some blank cells. If you'd like to start a new workbook, select a blank spreadsheet instead. If you already have a dataset, then choose the workbook that contains the right information. Launch Excel on your device and choose the correct workbook. Here are four steps for how to add commas in Excel: 1. Related: A Step-by-Step Guide for How To Divide in Excel How to add commas in Excel When inserting dates into Excel, it might be valuable to use commas to make them easier to read.

If you have several addresses to add commas to, then you might consider using an alternative method to achieve this.ĭates: Depending on your profession, you might use dates to signify deadlines, deliverables or important events. While you can type them individually, it might be beneficial to use a quicker method to add each comma.Īddresses: When writing addresses, you might use commas after the street name and after the city. Names: If you have a list of names in your dataset, then you might want to separate them by columns. Here are some situations in which it may be beneficial for you to use commas in Excel: If, however, you want to add commas to a large group of cells, an entire column or an entire row, there are alternative methods that can make the process much quicker and easier than doing it manually. You can select the cell you want to edit and add a comma from your keyboard, just as you enter and edit data in cells normally. If you want to add commas to a single cell or a small group of cells on your Excel spreadsheet, it's typically easy to do this manually. In this article, we provide steps for how to add commas in Excel, explain when you may want to use these marks and offer tips for completing this task. If your job requires you to use Excel or you're trying to develop your computer skills, you may benefit from learning about this process. Users may want to add commas to their Excel data to make it clear and understandable.

Commas are versatile punctuation marks that can separate items in a list, mark large numbers and organize information in other ways.

Excel add commas in numbers