Creating a Useful Spreadsheet From Miva Merchant Order Export Data: Step Four

This final step is not necessary in order to use the spreadsheet, however, you may want to eliminate the columns containing the old, inflated data.

Because the new columns get their data from formulas that reference the values in the old columns, you can’t just delete the old columns without losing your new data.Instead, you must first convert the data in the new columns from formulas to values.

Step Four: Convert the new Excel data from formulas to values, then delete the old columns

  1. Highlight column AK (TAX).Click the Edit menu and select Copy.
  2. Click the Edit menu again, and click Paste Special.Under Paste, select Values, then click OK.
    Paste Special
  3. Highlight column AJ (ORDER_TAX).Delete.
  4. Highlight column AL (SHIPPING).Click the Edit menu and select Copy.
  5. Click the Edit menu again and select Paste Special.Under Paste, select Values, then click OK.
  6. Highlight column AK (ORDER_SHIP).Delete.
  7. Highlight column AM (TOTAL).Click the Edit menu and select Copy.
  8. Click the Edit menu again and select Paste Special.Under Paste, select Values, then click OK.
  9. Highlight column AL (ORDER_TOTL).Delete.Your spreadsheet is now ready for use.
    Final Spreadsheet
Previous page