If I setup columns containing data next to a list (Excel 2003), and navigate between the list and the remainder of the spreadsheet, excel always presents a new view that repositions the viewable area in the spreadsheet. This also presents itself as a problem when I navigate between worksheets and/or applications. Is there anyway to change Excel's behavior to keep the same position on the screen? (Freezing panes will not work, nor will splitting windows).
Thanks in advance.