Menu
Selecting data in different columns for an excel chart youtube. How to select non contiguous text in mac os x to copy paste. How to select multiple non adjacent cells in excel on mac generated on lbartman.com. Show printable version!!! Hide the show.
In this video, we'll look at how to use INDEX and MATCH with an Excel Table. Using INDEX and MATCH with an Excel Table is wonderfully straightforward.
![Plant cells Plant cells](https://library.barnard.edu/sites/default/files/images/inline/select.gif)
In this video, we'll build a simple dashboard by setting up a slicer to control to more than one pivot chart.
In this video, we'll look at how to build a two-way lookup with INDEX and MATCH, using an an approximate match.
In this video, we show you how to move a pivot table style from one workbook to another.
In this video, we'll look at how to update data in a pivot chart. Like pivot tables, pivot charts require a refresh.
Related Articles
- 1 Make a Two Column Spread Sheet on Microsoft Excel
- 2 Combine Worksheets Inside an Excel Spreadsheet
- 3 Fill a Formula Across Excel
- 4 Insert a Caret in Excel
Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column using one of the three techniques below. Each of the tools varies slightly in its implementation, but they all provide the same results.
Keyboard Shortcut
1.Select the range of cells in which you want to enter the same data.
2.Type the data. The entry appears in the first selected cell.
3.Press 'Ctrl-Enter' on the keyboard. Excel fills the other cells in the column with the same value.
Fill Handle
1.Enter the data into the first cell in the column.
2.Click the cell to select it, and then hover your mouse pointer over the bottom right corner of the cell until your pointer turns into a black '+' sign. This corner is the 'fill handle.'
3.Click the fill handle and drag it down until you cover the desired rage of cells in the column, and then release the mouse button. Excel copies the value in the first cell to the other cells.
Copy and Paste
1.Enter the data into the first cell in the column, and then press 'Enter.'
3.Select the other cells in which you want to repeat the same data.
4.Right-click anywhere on the selected range of cells, and then click the first clipboard icon under 'Paste Options.' Excel pastes the copied data into all of the selected cells.
Tip
- The fill handle method works for both columns and rows, while the copy and paste method can be used to populate a row, column or even an entire block of cells with the same value.
Warning
- Information in this article applies to Microsoft Excel 2007, 2010 and 2013. It may vary slightly or significantly with other versions or products.
References (1)
About the Author
Alan Sembera began writing for local newspapers in Texas and Louisiana. His professional career includes stints as a computer tech, information editor and income tax preparer. Sembera now writes full time about business and technology. He holds a Bachelor of Arts in journalism from Texas A&M University.
Cite this Article Choose Citation Style
Sembera, Alan. 'How to Fill a Column with the Same Data in Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/fill-column-same-data-excel-70773.html. Accessed 22 November 2019.
Sembera, Alan. (n.d.). How to Fill a Column with the Same Data in Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/fill-column-same-data-excel-70773.html
Sembera, Alan. 'How to Fill a Column with the Same Data in Excel' accessed November 22, 2019. http://smallbusiness.chron.com/fill-column-same-data-excel-70773.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.