How to Copy Columns in Excel Using VBA. Many small businesses use Microsoft Excel for day-to-day accounting and other spreadsheet tasks.

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.

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.

If you prefer keyboard shortcuts, use the following steps to insert rows and columns: Press [Shift]+ [Spacebar] to select an entire row. Press [Ctrl]+ [Spacebar] to select an entire column.