Customzing view with freeze panes

I create two two spreadsheets in each of 12 workbooks on a daily basis. In each of these spreadsheets I'm freezing the view at G12 on one, at E12 on the other. Each spreadsheet has about 50 columns, but I'd like my default view to show only what's to the left of the freezepoint (say, A through F), and the last 5 columns, which vary on a daily basis. How would I go about doing this? I know I can use

Please Login or Register  to view this content.

to find my last column, but how do I make it and the four to the left of it scroll to the freeze point but not behind it?

Thanks in advance for any help on this.