Displaying Data with Excel Inplace 
Use
By default, the data is displayed in the ALV Grid Control view. Alternatively, you can switch to the Excel view. Your data is sent to Excel and displayed instead of the grid. The toolbar of the ALV Grid Control remains in unchanged form; you can continue to use the functionality provided in the Excel view as well.
Prerequisites
To display the Excel Inplace view, you must have Excel installed on your computer.
Procedure
To display the data
in Excel, choose 
® Excel Inplace.
In full-screen mode, choose Views ® Microsoft Excel.
Result
Your data is sent to Excel and displayed there instead of in the grid. The information and settings are transferred from the grid view and displayed in the format sheet. When you do so:
● The column headers are copied over
● The column sequence and the column width are copied over
● The lead columns are displayed in turquoise
● Totals and subtotals from the grid view are copied over and displayed in the same way (see display of totals and subtotals)
In addition to the displayed Format sheet, other sheets are provided:
● Header (only of significance in full-screen mode): In this sheet additional header information is displayed above the list data
● Pivot: This sheet provides you with the pivot table for the list data
● Sub1-Sub10: In these sheets you will see only the subtotals for the corresponding subtotal level
● RawData: The list data is displayed without any other information, such as lead columns, header information, totals or subtotals.
● RawHeader (only of significance in full-screen mode): Only the header information is displayed.
These sheets are based on the default templates delivered by SAP. Mit Template wird die Vorlage für die Excel-Sheets bezeichnet. You can also define your own or cross-customer templates according to your needs in which you add a company logo to the sheets, for example. See Managing Templates.
You should not change the data in the executed sheets. If you want to edit the data, first create your own worksheet using Insert ® Table. Changes that you make to the data will not be copied to another view if you change the view again.
The functions of the ALV Grid Control toolbar that are offered are also available in Excel. The changes that you make using the ALV Grid Control toolbar are copied to the new view when you switch.
● Calculating and deleting totals
● Calculating and deleting subtotals
The settings that you make on the Display tab are not displayed in Excel, but they are copied over when you switch to ALV Grid Control.
In the Excel view you do not have the option of defining filters and sorts using the toolbar of ALV Grid Control. You can use the filter and sorting options from Excel. These changes are not copied over when you switch the view.
● Displaying graphics for lists
Procedure
To return to the
grid view, choose ® Grid.
In full-screen mode, choose Views ®SAP List Viewer.