Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...

Step 3: In this case, we added an "Expenses" column, and it now shows between Last name and Sales. Mark Coppock/Digital Trends Adding a partial column Sometimes, you want to add a new column to ...

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

2. Select the column to the right of where you want a new column. (Excel will insert the new column directly in front of it.) Select an entire column by clicking on its letter name at the top. 3.

Move your cursor to the blank column (L) at the far-right side of your table. Type the name of the new column in row 3 and notice that Excel adds the filtering and style format automatically.

First, create a new column by entering Debit in cell E2. If you’re working with a Table object (as I am), Excel will automatically extend the Table. In E3, enter the following expression: ...