1. Identify the column(s) that need to be reverse coded.
2. Insert a new column next to the column(s) that need to be reverse coded.
3. In the first cell of the new column, enter the following formula:
   Code:

   =6-A1

   (assuming the original values are in column A).
4. Copy the formula down to all the cells in the new column that correspond to the original data set.
5. Select the entire new column and copy it.
6. Right-click on the original column that needs to be reverse coded and select "Paste Special".
7. In the "Paste Special" dialog box, select "Values" and "Multiply" options, then click "OK".

This will replace the original values with their reverse-coded counterparts in the selected column(s). You can then delete the new column that you created in step 2.