How to Make a 2 Column List in an Excel Spreadsheet

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Making a two-column list in a Microsoft Excel 2007 spreadsheet is easy and can help you in many ways. Using a two-column Excel list is a great way to keep track of your bank balance, to make a list of unpaid invoices or to compile expenses for a tax return. When you open Excel on your computer, the columns and rows are already defined for you, so entering information into the columns and formatting the information are all that need to be done.


Step 1

Open Microsoft Excel 2007 on your computer. As you can see, several columns and rows already come up in Excel.

Video of the Day

Step 2

Place a title at the top of the spreadsheet. This is very important so that you know what is actually listed in the spreadsheet. Place the title at the very top of the page, starting in cell A1.


Step 3

Add titles to the two columns that will compose the list. Place the column titles a few lines down from the title of the spreadsheet. This will help you remember what information is in each column. Center the columns by highlighting both cells and click on the centering icon (showing centered text) in the "Alignment" section of the "Home" tab.


Step 4

Bold the title of the spreadsheet and the titles of the columns. Highlight the cells to be bolded and click on the bold icon in the "Font" section of the "Home" tab.

Step 5

Skip a line after the column titles and enter your data into columns A and B. You can enter text or numbers, depending on the purpose of the two-column list.


Step 6

Format any numbers that you have entered. If you entered dates, monetary amounts or regular numbers in the columns, you can format them so that all of the numbers look the same. To do this, highlight all of the cells with numbers that you want to format in the same way. Right click and select "Format Cells." Use the tools in the "Number" tab to format the cells according to your purpose.


Step 7

Create totals for columns with numbers, if needed. To do this, click on the cell where you want the total to be, and then click on the sigma symbol (it kind of looks like an E) in the "Editing" section of the "Home" tab. The following will appear in the cell: =SUM(). Click on the first cell that you want included in the total, and drag down to highlight the last cell to include in the total. Press "Enter" and the total will be inserted.



Report an Issue

screenshot of the current page

Screenshot loading...