Scroll bar Issue in Excel Reports

Scroll bar Issue in Excel Reports

Issue1-Removing Scroll Bars from Excel Reports
Issue2-Removing Row Numbers and column Names

Issue Description-While Creating any Excel report and viewing them in browser were having Scrooll bars in it and it was showing Row numbers(1,2,3...) and Column Names(A,B,C...) which were not required

Issue Screensot.

If you see the above Screenshot It contain

Issue 1 Solution

The Reason of having Scroll Bars in Excel Reports is due to size of Spread sheet
Select the Cell which are unused in order to select all the unused Cells
click on first unused column
Press ctrl +Shift+down key+Right key
It will select all the Unused column
Right click
Hide
It will hide all the unused Rows and COlumnn
Once you will hide the unused cells scroll bars wont't appear in your report


Issue 2 Solution
In order to remove the Row Names and columnNames

Click on view Menu
Uncheck Heading

Save Report
View in browser

Report won't have scroll bars ,Rows and column Heading.