To copy columns from one Excel spreadsheet to another, you need to click on the column name first in the source file. Then, open the destination file and press Ctrl+V.

You can Cut or Copy Paste Columns and Rows in Excel spreadsheet - and keep the formulas and formatting using this step-by-step guide.

If you want, you can copy the contents of an entire sheet from an Excel workbook in a few simple steps, then paste it into another sheet or program.

If you already have your employees listed in an Excel spreadsheet, just copy the column containing their names and then paste that into the first column for their names in your sick leave spreadsheet.