While you click on File Menu, and go to the Spreadsheet Settings, and at last set the Locale settings of your choice you get one base forex in your spreadsheet. This is the way in which you are currently working. After setting the bottom currency you add more currencies...