Question: how to open multiple spreadsheets in excel 2010?
Answer: Open the workbook or workbooks that contain the worksheets that you want to view at the same time.
Do one of the following: ... 
On the View tab, in the Window group, click Arrange All.
Under Arrange, click the option that you want.