Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Merging the Values Right-click the column header immediately to the right of the second column and select "Insert" to add a new column, if necessary.

Type the name of the new column in row 3 and notice that Excel adds the filtering and style format automatically. 11. It’s also easy to add new records.