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 ...

Now, switch to the new Excel file in which you would like to retain the column width of the source file. Go to the File tab located on the Ribbon menu. Under it, click the Paste drop-down arrow.

Excel Tip No. 6: Add or Delete Columns Keyboard Shortcut. Managing columns and rows in your spreadsheet is an all-day task. Whether adding or deleting, you can save a little time when you use this ...

Otherwise, you will need to delete year-specific information from a copy of the file each time you start a new year. Information in this article applies to Microsoft Excel 2010.