What steps to take to get the first spread sheet to look like the second?

SALES & EXPENSES Compatibility Mode]- Excel Insert Page Layout Formulas Data Review View Add-ins Nuance PDF Tell me what you want to do.. B 1 uwEI ? ?-A? Merge & Center v s-% , sg.08 Conditional Format as Linked Cell Format Painter Clipboard Ali Bit by Bit Distributors, Inc Nationwide Sales Report State Region Store Opened #Years Open Division Rep Last Name Rep First Name Rep Full Name Los Angeles CA Los Angeles CA Los Angeles CA 112,000 2/15/1988 2 9 California Computers 11 California Computers 13 California Computers San Francisco CA 2/15/1988 Hardware Anderson 2/15/1988 85,000 Peripherals Hannign Paul Hardware Schuman Pittsburgh PA 5/1/1990 Peripherals Schuman Saah 20 Compu-Products, Inc Providence RI 55,400 4/25/1989 8/30/1991 Peripherals Chung Central New York 110,000 29 South Beach Computers Ft. Lauderdale FL Ft. Lauderdale FL Ft. Lauderdale FL 10/10/2000 Capricho 32 South Beach Computers 33 South Beach Computers 34 South Beach Computers 35 River Technology, Inc. 36 River Technology, Inc 37 River Technology, Inc. 10/10/2000 0/10/2000 97,000 Peripherals Sanchez Portland 12/15/1987 Peripherals Black 40 Bradley Computers 41 Bradley Computers 12/15/1987 Rep List | East |