Please go to report > Print Ledgers > ok > excel > select exit by right clicking it to view the customize part like the picture below.

 

 

Then, select copy to create a  new excel report > follow all the description exactly like the picture below