Tuesday, December 11, 2012

How to Make a 2 Column List in an Excel Spreadsheet


1. Open Microsoft Excel 2007 on your computer. As you can see, several columns and rows already come up in Excel.
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.
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.
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.
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.
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.
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.

Blogger news