To keep or float the reference codes in columns M1 through P1 always in view on the right side of the spreadsheet, you can use the

1. Select the cell in column Q1, which is the first cell to the right of the reference codes.
2. Click on the View tab in the ribbon at the top of the Excel window.
3. In the Window group, click on the Freeze Panes dropdown menu.
4. Select the option "Freeze Panes" from the dropdown menu.
5. You should now see a horizontal line appear just above row 1 and a vertical line appear just to the left of column Q. This indicates that the rows above and columns to the left of the selected cell are frozen.
6. Scroll down and to the right to confirm that the reference codes in columns M1 through P1 are now always in view on the right side of the spreadsheet.

That's it! Now you can work with your large spreadsheet and always have the reference codes in view on the right side.